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

67 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
whydah194295(None) 
whidah1634801whidah
whydahs2041881whydahs
khedah1743642khedah
whidahs1743332whidahs
ayah108022993_ay_ah
chadar1239353chadar
chalah143511663chalah
chetah14399583chetah
chuddah17263253chuddah
dah78148983___dah
gaydar1135503gaydar
hadal95518123_hadal
hah910655223_h__ah
heyday1635143heyday
hodad10311353_hodad
horah117922053_horah
houdah1335173houdah
howdah1634723howdah
hydra12249223_hydra
hydrae13258573_hydrae
hydras13239313_hydras
hydro12259423_hydro
hyla106716513_hyla_
hylas114815903_hylas
hypha1637383_hypha
hyrax1838033_hyrax
keddah1534273keddah
kheda1346533kheda_
khedahs1852953khedahs
khedas1446313khedas
mayday1535883mayday
mynah13569563_mynah
odah87018933__odah
pardah123412823pardah
payday1536613payday
phyla13469183phyla_
phylae14458733phylae
phylar14437373phylar
purdah12288753purdah
rayah116013503ray_ah
rhyta1135083rhyta_
shah105627783sh__ah
shibah14387473shibah
shivah15488543shivah
wallah124011993wallah
waylay1535453waylay
wha96422073wh__a_
wham125321693wh__am
whap125119643wh__ap
what105434073wh__at
wheal115716183wh_eal
wheat114924573wh_eat
whenas124610463whenas
wheyish1944063wheyish
which163910083wh_ich
whid115418873whid__
whids125413983whid_s
whish144512923wh_ish
whoa106615203wh_oa_
whoosh15244353whoosh
why126920013why___
whys137011663why__s
width12310963w_idth
wych154011883w_y_ch
yah99046353__y_ah
yeah106725413__yeah

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 Filter1786911127160.546327272.9
2DLD Change Limit112716675.31321215.1
3Display Results67670.0164187.5
 (SQL Overall)178691675.87530415.5
 
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.