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

88 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
keddahs164292(None) 
keddah1534271keddah_
keblahs1634562keblahs
khedahs1852952khedahs
bedders113513383bedders
bedlams1237053bedlams
bedpans1237173bedpans
beldams1237053beldams
bendays13327513bendays
buddhas1463263buddhas
cedars93312833ce_dars
cheddars15234383cheddars
chuddahs18222583chuddahs
dahs88231813___dahs
dedans85915073de_dans
deodars937623deodars
eddies83313163_eddies
eddoes8199143_eddoes
edhs86212103_e_d_hs
emdash12244113_emdash
endash10297123_endash
ephahs1435503_ephahs
fellahs13428393fellahs
gerahs1039413ge_rahs
goddams1233983goddams
heddles123311623heddles
heydays1734143heydays
houdahs1434243houdahs
howdahs1733613howdahs
kaddish16317973kaddish
kasbahs1634363kasbahs
keas86337093ke__a_s
kebabs14418513ke_babs
kebars124112493ke_bars
keblah1545313keblah_
kedges124812983ke_dges
kenafs1337113ke_nafs
kendos114510663kend_os
keypads1743343keypads
keypals1634353keypals
keyways2043373keyways
khaddars1741993khaddars
khedah1743643khedah_
khedas1446313kheda_s
kiblahs1634153kiblahs
kidders13399173kidders
kiddies133412283kiddies
kiddish16276583kiddish
kiddoes13387063kiddoes
kiddos12416863kidd_os
kiddush16242483kiddush
kidnaps1453323kidnaps
medals94218053me_dals
meddles113213253meddles
medials103914733medials
medians103214213medians
medias93620783media_s
medlars10259443medlars
middays14335663middays
neddies92710703neddies
odahs95610083__odahs
pardahs13289673pardahs
pedals94316033pe_dals
peddles112913703peddles
pedlars103210213pedlars
purdahs13285483purdahs
redans75421023re_dans
redbays1336013redbays
redcaps1247073redcaps
reddens9259783reddens
redders93615343redders
reddish1238033reddish
reddles93315773reddles
redds74617833redd__s
redears82814453redears
redials84416883redials
redias74523603redia_s
redraws11218473redraws
sedans74816093se_dans
selahs9313213se_lahs
sendals81912263sendals
serdabs1035323serdabs
tedders94010233tedders
teddies92711283teddies
wedders123610723wedders
whidahs1743333whidahs
whydahs2041883whydahs
yeahs115214553ye__ahs

Search took 6 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 Limit134027885.51624297.9
3Display Results88880.0302933.3
 (SQL Overall)178691885.95230022.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.