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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
elderly115495(None) 
alderfly1542752alderfly
eagerly1136052eagerly
elder64020022elder__
elders74817302elder_s
orderly1135762orderly
readerly1245082readerly
tenderly1245292tenderly
addedly1344293addedly
alder65421913alder__
alders74218423alder_s
alertly1046793al_ertly
alienly1037503alienly
allergy1144503allergy
angerly1137773angerly
badgerly1543283badgerly
bluely113310083blue_ly
celery1139623cel_er_y
cheerly15417603cheerly
clearly1236663clearly
clergy1234993cl_ergy
clerkly1643573cl_erkly
cleverly1643463cleverly
dearly104615323__dearly
delly96023873__delly
deray95024183__deray
derby114715343__derby
derry94721373__derry
early85324123e__arly
easterly11246643easterly
eatery95316353eater_y
edgily1136063e_dgily
eely77725213e__e_ly
eerily92913563e__erily
eery76129623e__er_y
eider64624743eider__
eiders74321363eider_s
elatedly1244793elatedly
elderlies1044673elderlies
eldest72912683elde_st
eldress835003eldress
elegy939303el_e_gy
eluder73712213eluder__
eluders8409903eluder_s
elver85216243elver__
elvers93814983elver_s
emery104814333e_mer_y
empery1348683emper_y
ender64325863ender__
enders74324053ender_s
energy10137513e_nergy
equerry1943053equerry
evenly1236993e_venly
every115215453e_ver_y
expertly2044703expertly
fadedly1535453fadedly
ferly115517353__ferly
fleetly1336323fleetly
gelder84613713gelder__
gelders93812573gelder_s
glegly1134873gl_egly
goldenly1344103goldenly
hellery13329213heller_y
innerly1037133innerly
jadedly1934013jadedly
leadenly1244733leadenly
leerily1037633_leerily
leery85919133_leer_y
levelly1335853levelly
liefly1266363_liefly
loverly1346973loverly
meagerly1444003meagerly
melder93915813melder__
melders103213913melder_s
miserly12329823miserly
modernly1443843modernly
nudely10299033nude_ly
older65121173older__
overly122411363_overly
pedlery13297083pedler_y
queerly1934233queerly
rudely10389973rude_ly
rudery10419033ruder_y
seldomly1442393seldomly
sheerly13337703sheerly
silverly14284313silverly
sleekly14325193sleekly
slenderly1343453slenderly
soberly1236943soberly
soldierly13222903soldierly
underlay12147653underlay
utterly1035443utterly
welder102914413welder__
welders113313413welder_s
westerly1445553westerly
widely133311033wide_ly

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit134027966.56320421.6
3Display Results96960.0462087.0
 (SQL Overall)178691967.01525472.7
 
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.