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 “purge” 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.

129 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
purge8532460(None) 
gurge75419781gurge
parge85831851parge
pure65543331pur_e
puree74632841puree
purged104918261purged
purger94717231purger
purges94421761purges
purse76028891purse
spurge93711321spurge
surge65027691surge
urge54722421_urge
aurae54128112aurae
barge85631022barge
budge94619882budge
bulge86419872bulge
burg74930362burg_
burgee97120592burgee
burger94020792burger
burgh115216032burgh
burgle94815862burgle
burgs84924092burgs
burke115122762burke
burse75527252burse
cure66149122cur_e
curie74533042curie
curse75829142curse
curve104920022curve
dirge75117072dirge
dure56341812dur_e
forge95126942forge
fudge105315532fudge
furze176815812furze
gorge76423892gorge
gurged95513362gurged
gurges84716862gurges
gurgle83912472gurgle
huge86321652hu_ge
judge144714162judge
large65325462large
luge55531642lu_ge
lunge65323802lunge
lure45142462lur_e
marge85328332marge
merge84523692merge
mure65941332mur_e
murre74821072murre
nudge74616432nudge
nurse54420122nurse
ourie54027302ourie
page76036102p_age
parae76335702parae
pare66760842par_e
parged104922042parged
parges94529542parges
parget94529392parget
pargo86723722pargo
parle75836162parle
parse75236992parse
parve109824852parve
peage84723572peage
pere66450262per_e
perse75429522perse
phage115113672phage
plage84520402plage
plunge93811052plunge
pore66451262por_e
porgy116916122porgy
pree67044732p_ree
prude84615972prude
prune75119632prune
puce85127882pu_ce
pudgy124911162pudgy
pug65337182pu_g_
pugged114314532pugged
puggy124612322puggy
pugh106619232pu_gh
pugree92112472pugree
pugs76332772pu_gs
puke105025462pu_ke
pule65040952pu_le
pulse74219972pulse
pung75429632pung_
pungle94413572pungle
pungs85422222pungs
pupae96515642pupae
pur56840552pur__
purda82914692purda
pureed95017812pureed
purees84721682purees
purer75127902purer
purfle112511182purfle
purgers104714002purgers
puri65931442pur_i
purin75527592purin
purine85321892purine
puris75332022puris
purl65631422pur_l
purled94520752purled
purls74723352purls
purple102712682purple
purr64925812pur_r
purred94218072purred
purrs75320432purrs
purs65641042pur_s
pursed95220882pursed
purser85020472purser
purses84826372purses
pursue84512252pursue
pursy105016412pursy
purty105019402purty
purvey14559572purvey
pyre94925552pyr_e
sarge65531132sarge
serge64727472serge
sparge94216052sparge
splurge1044762splurge
spurges104111652spurges
sure45447412sur_e
surged84118882surged
surger74320092surger
surges73924592surges
surgy95118522surgy
targe65227092targe
upsurge10134332upsurge
urged75316032_urged
urger64116472_urger
urges64619912_urges
verge93419842verge

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538001291.67332157.8
3Display Results1291290.0304300.0
 (SQL Overall)1786911291.99989390.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.