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

62 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
doyenne114388(None) 
doyennes1244361doyennes
cayenne1244602cayenne
donne65520462do__nne
doyen95014412doye_n_
doyens104810222doye_ns
benne76521123__benne
bonne75124713bo__nne
cayenned1443163cayenned
cayennes1345013cayennes
codeine103815033codeine
defence1339893defence
defense1137503defense
demesne1035573demesne
dene56643413d__e_ne
denned84215633d__enned
dense65923503d__ense
detente83313603detente
diene65720133d_ie_ne
docent92918683doce_nt
docents102810803docents
dogbane1135653dogbane
doggone1035683doggone
dogvane1243853dogvane
domaine10610503domaine
domine92918253do_mine
dominie103111643dominie
done55747913do___ne
donee66931013do__nee
donna66215033do__nna
donned85015743do__nned
donnee74317063do_nnee
dourine8311453dourine
dovekie15134313dovekie
doven94718553dove_n_
dovened12389063dovened
dovening13238363dovening
dovens104413903dove_ns
dozen155017473doze_n_
dozened18377453dozened
dozening19236203dozening
dozens164612463doze_ns
dozenth2044323dozenth
duende836923d_uende
duenna734593d_uenna
dyeing11428213d_yeing
dyne85320933d_y__ne
eocene8311613eoce_ne
hyenine1336953_hyenine
joyance1944773joyance
lozenge1743243lozenge
moderne1037123moderne
novenae1046323novenae
oleine6313793_oleine
penne75423853__penne
polyene1259363polye_ne
potence11711363potence
rotenone847093rotenone
someone938813someone
tonne54921433to__nne
yenned10409383__yenned
yente86220043__yente

Search took 10 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.403443402.0
2DLD Change Limit134027629.03314837.5
3Display Results62620.0163875.0
 (SQL Overall)178691629.45218905.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.