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 “purges” with Change Limit: [1] [2]

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

131 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
purges9442176(None) 
gurges84716861gurges
parges94529541parges
purees84721681purees
purge85324601purge_
purged104918261purged
purger94717231purger
purgers104714001purgers
purses84826371purses
spurges104111651spurges
surges73924591surges
urges64619911_urges
aures55137092aur_es
barges94528252barges
budges104820132budges
bulges95919322bulges
burgee97120592burgee
burgees104915892burgees
burger94020792burger
burgers103918572burgers
burgess10409342burgess
burghs12519922burghs
burgles105615962burgles
burgs84924092burg_s
buries84633272buries
burkes124421312burkes
burses84425512burses
cures75645432cur_es
curies84934022curies
curses85328272curses
curves114619282curves
dirges84915102dirges
dures65635922dur_es
forges105024262forges
fudges114314502fudges
furies95126372furies
furzes186613692furzes
gorges85321892gorges
gurge75419782gurge_
gurged95513362gurged
gurgles94312872gurgles
judges153713462judges
juries134120632juries
larges74824232larges
luges65928752lu_ges
lunges76123422lunges
lures56138532lur_es
marges94525712marges
merges94122492merges
mures75937222mur_es
murres85019042murres
nudges84114742nudges
nurses63919352nurses
pages85235072p_ages
pares77164482par_es
parge85831852parge_
parged104922042parged
parget94529392parget
pargets105215192pargets
pargos95719042pargos
paries84742512paries
parles86334402parles
parses85534702parses
peages94321852peages
peres76246642per_es
perses85428062perses
phages125213512phages
plages94520152plages
plunges104011612plunges
pores75849032por_es
porgies103017002porgies
prees75937172p_rees
pries74339532p_ries
prudes94215442prudes
prunes83419062prunes
pubes94423402pu_bes
puces94924632pu_ces
pugged114314532pugged
pugree92112472pugree
pugrees10218522pugrees
pugs76332772pu_g_s
pukes114523022pu_kes
pules74538812pu_les
pulses83818662pulses
pungles104013712pungles
pungs85422222pung_s
purdas92612262purdas
pure65543332pur_e_
puree74632842pur_ee
pureed95017812pureed
purer75127902pur_er
purest84021932pur_est
purfles122511842purfles
purines94420762purines
purins83722652purins
puris75332022pur_is
purled94520752purled
purls74723352pur_ls
purples112712832purples
purred94218072purred
purrs75320432pur_rs
purs65641042pur__s
purse76028892purse_
pursed95220882pursed
purser85020472purser
pursers93916092pursers
pursues94111372pursues
purvey14559572purvey
purveys15615902purveys
puses75532202pu_ses
pushes114621662pushes
pusses84322842pusses
putzes174212522putzes
pyres105523882pyr_es
sarges75128592sarges
serges74225972serges
sparges104016342sparges
splurges1145162splurges
spurge93711322spurge_
surge65027692surge_
surged84118882surged
surger74320092surger
surgers83517482surgers
targes74524602targes
turves94212692turves
upsurges11144802upsurges
urge54722422_urge_
urged75316032_urged
urger64116472_urger
urgers73313622_urgers
verges104320182verges

Search took 5 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 Filter178691825510.360496363.9
2DLD Change Limit825511314.48618401.9
3Display Results1311310.0462847.8
 (SQL Overall)1786911314.89236527.2
 
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.