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

133 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
purees8472168(None) 
prees75937171p_rees
pugrees10218521pugrees
puree74632841puree_
pureed95017811pureed
purges94421761purges
purses84826371purses
agrees74915322agrees
aures55137092aur_es
aureus65314882aureus
brees75632552_brees
burets84321262burets
burgees104915892burgees
buries84633272buries
burkes124421312burkes
burses84425512burses
curers84923192curers
cures75645432cur_es
curets84922342curets
curies84934022curies
curses85328272curses
curves114619282curves
cuvees1139372cuvees
drees65628522_drees
dures65635922dur_es
duress74712062duress
frees86131392_frees
furies95126372furies
furzes186613692furzes
fusees95416402fusees
fuzees184910752fuzees
grees65132472_grees
gurges84716862gurges
hirees95117292hirees
jurels133710582jurels
juries134120632juries
larees65323112larees
lurers64217492lurers
lures56138532lur_es
lurexes1436072lurexes
mures75937222mur_es
murexes1636972murexes
murres85019042murres
nurses63919352nurses
pareos87023772pareos
parers85530742parers
pares77164482par_es
pareses94718882pareses
pareus85420742pareus
parges94529542parges
paries84742512paries
parles86334402parles
parses85534702parses
payees114812902payees
pees65257372p__ees
peres76246642per_es
perses85428062perses
pewees11311392pewees
pores75849032por_es
pourers93513672pourers
pree67044732p_ree_
preed85128122p_reed
preen75925052p_reen
preens85020112p_reens
preps96220692p_reps
prese75228382p_rese
press75425952p_ress
prexes154915952p_rexes
preys105717782p_reys
prezes173614692p_rezes
pries74339532p_ries
prudes94215442prudes
prunes83419062prunes
pubes94423402pu_bes
puces94924632pu_ces
pugarees11195492pugarees
puggrees12194262puggrees
pugree92112472pugree_
pukes114523022pu_kes
pulers83820282pulers
pules74538812pu_les
pulses83818662pulses
purdas92612262purdas
pure65543332pur_e_
purely114013632purely
pureness101110182pureness
purer75127902pur_er
purest84021932purest
purfles122511842purfles
purge85324602purge_
purged104918262purged
purger94717232purger
purgers104714002purgers
purines94420762purines
purins83722652purins
puris75332022pur_is
purled94520752purled
purls74723352pur_ls
purples112712832purples
purred94218072purred
purrs75320432pur_rs
purs65641042pur__s
purse76028892purse_
pursed95220882pursed
purser85020472purser
pursers93916092pursers
pursues94111372pursues
purvey14559572purvey
purveys15615902purveys
puses75532202pu_ses
pushes114621662pushes
pusses84322842pusses
puttees93612912puttees
putzes174212522putzes
pyrenes123511222pyrenes
pyres105523882pyr_es
pyrexes19305842pyrexes
rees45364192__rees
rupees8312572rupees
sarees65329942sarees
screes85023972screes
sirees64624582sirees
sprees85620642sprees
spurges104111652spurges
surges73924592surges
threes97117322threes
trees55835762_trees
tureen63312722tureen
tureens7289872tureens
turves94212692turves
tutees6514552tutees
ureas55826012_ureas
urges64619912_urges

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 Filter178691825510.343520965.0
2DLD Change Limit825511332.17038041.9
3Display Results1331330.0334030.3
 (SQL Overall)1786911332.54670185.0
 
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.