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

65 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
doyennes124436(None) 
doyenne1143881doyenne_
cayennes1345012cayennes
doyens104810222doye_n_s
bennes86019013__bennes
bonnes85621453bo__nnes
cayenne1244603cayenne_
cayenned1443163cayenned
codeines113114523codeines
defences1439633defences
defenses1237913defenses
demesnes1137083demesnes
denes65639723d__e_nes
denies74729643d__enies
denned84215633d__enned
detentes92712873detentes
dienes75719903d_ie_nes
doblones1136763doblones
docents102810803doce_nts
dogbanes1245433dogbanes
doggones1135713doggones
dogvanes1344303dogvanes
domaines11611063domaines
domines102918973do_mines
dominies113513193dominies
dominoes11349043dominoes
donees74519493do__nees
doneness9411513doneness
donnas75511323do__nnas
donne65520463do__nne_
donned85015743do__nned
donnee74317063do__nnee
donnees84210363do_nnees
dopeyness1543473dopeyness
dourines9311373dourines
dovekies16115003dovekies
dovened12389063dove_ned
dovens104413903dove_n_s
doweries12411933doweries
doyen95014413doye_n__
doylies114512573doy_lies
dozened18377453doze_ned
dozens164612463doze_n_s
dozenths2142793dozenths
duendes938193d_uendes
duennas834143d_uennas
dyeings12374643d_yeings
dynes95917583d_y__nes
joannes1436243jo_annes
johannes1842943johannes
joyances2044413joyances
lozenges1843053lozenges
modernes1138423modernes
oleines7313393_oleines
oogenies9311583oogenies
openness1035473_openness
oyesses1037333_oyesses
oyezes1835053_oye_zes
polyenes13510063polye_nes
potences12710693potences
rotenones956343rotenones
someones1039063someones
tonnes65320853to__nnes
yenned10409383__yenned
yentes95517603__yentes

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 Filter1786911461620.420425454.8
2DLD Change Limit146162656.67321903.5
3Display Results65650.0302166.7
 (SQL Overall)178691657.12325086.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.