Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “graupels” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
graupels113310(None) 
graupel1034131graupel_
grapes95123122gra_pe_s
grapnels1134392grapnels
grapples13348122grapples
graspers11338402graspers
gravels113611142gra_vels
groupers11358642groupers
gruels73910152gr_u_els
rappels11448802_rappels
appels104312793__appels
carpels115315463_carpels
chapels14429153cha_pels
crapes104727693cra_pe_s
crappers144011023crappers
croupes114613103croupe_s
cupels10310203__cupels
drapers105313353dra_pers
drapes95419653dra_pe_s
drupes94912653dr_upe_s
frappes14328383frappe_s
gapers94520473g_a_pers
gapes86030823g_a_pe_s
gaspers105014133g_aspers
gaugers94211713g_augers
gauges85915993g_auge_s
gauzes164710633g_auze_s
gavels105911093g_a_vels
gawpers13448313g_awpers
gospels1035593g_ospels
graals74112913gra__als
grabbers13337883grabbers
grabbles13339893grabbles
grabens10367003gra_bens
graces94523493gra_ce_s
graciles112511613graciles
grackles15309183grackles
graders94716013gra_ders
grades84926313gra_de_s
graduals1046203graduals
graduses1046453graduse_s
grafters12409193grafters
grails77518783gra__ils
grainers93012073grainers
grammes123611323gramme_s
grampas12399253gramp_as
gramps114114273gramp__s
grampus12356313gramp_us
grandees103211283grandees
grangers103011973grangers
granges93516523grange_s
grantees92510973grantees
granters93614143granters
granules939933granule_s
grape84824663gra_pe__
grapery13457953gra_pery
grapey126012303gra_pe_y
graphs124510153gra_p_hs
grapnel1035603grapnel_
grappas12357103gra_ppas
grapple12378003gra_pple
grappled14336093grappled
grappler13336193grappler
grapplers14274303grapplers
grasped11409063graspe_d
grasper10389793graspe_r
grasps9489253grasp__s
grasses84117343grasse_s
graters85419743gra_ters
grates75429893gra_te_s
gravel105313823gra_vel_
gravely14469063gra_vely
gravers114515273gra_vers
graves104624003gra_ve_s
gravies11314093gravie_s
gravures1234903gravure_s
grayness1235933grayness
grazers175112453gra_zers
grazes164519643gra_ze_s
graziers18387123graziers
gripers104011463gr_ipers
gripes94619873gr_ipe_s
grippers13358133grippers
grippes124810373grippe_s
gropers104813853gr_opers
gropes95220403gr_ope_s
grouped11419193groupe_d
grouper104210093groupe_r
groupies1137523groupies
groups94210513group__s
grousers93810733grousers
grouses84616543grouse_s
grouters95910083grouters
grovels11427813gr_ovels
gruel66014743gr_u_el_
grues65721963gr_u_e_s
grumes94415553gr_ume_s
lapels83712043_la_pels
laurels746663_laurels
paupers114311073_paupers
propels113412843pr_opels
rapers84327183_ra_pers
rapes75740723_ra_pe_s
rappees113611453_rappees
rappel104211953_rappel_
rappers113618443_rappers
raspers94415923_raspers
ratels64518213_ra_tels
ravels94717073_ra_vels
repels84318763_r_epels
rubels84112993_r_ubels
rupees8312573_r_upees
saurels749303_saurels
scalpels12345883scalpels
scaupers12378173scaupers
taupes8212673_taupe_s
tramels93812493tra_mels
trammels12295413trammels
trampers123210393trampers
tramples122610203tramples
trapes85024463tra_pe_s
trappers123711043trappers
travels104711293tra_vels
troupers10359443troupers
troupes94112853troupe_s
wrappers15306933wrappers
yaupers12337663_yaupers

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit1461621276.42322756.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.88925938.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.