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

78 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
tailleur84330(None) 
tailleurs942801tailleurs
tailer63823732tai_le_r
taille63116922taille__
tailles72516472taille_s
tailless8239082tailless
taller63721962ta_lle_r
tiller64222542t_ille_r
triller74215892trille_r
bailer85425253bai_le_r
baller83825203ba_lle_r
biller84923483_bille_r
brailler1036883braille_r
caller85125483ca_lle_r
caviller1337063caville_r
chiller124112183chille_r
derailleur115933derailleur
dialler848813dialle_r
driller84311883drille_r
eviller1056673eville_r
faille93414743faille__
failles102914133faille_s
faller94621233fa_lle_r
filler94623623_fille_r
friller104111743frille_r
giller74519733_gille_r
griller84513353grille_r
hailer94720343hai_le_r
hiller94421633_hille_r
iller54821293__ille_r
jailer134316683jai_le_r
killer104917953_kille_r
mailer84724183mai_le_r
mailless10248583mailless
malleus92911313ma_lleus
miller84625413_mille_r
nailer64119363nai_le_r
railer64524933rai_le_r
raillery1134953raillery
sailer63526103sai_le_r
sailless82410373sailless
siller64026063_sille_r
spiller92914333spille_r
stiller73414303stille_r
swiller103211663swille_r
tackler134013323tackle_r
tailed74424663tai_le_d
tailers73720183tai_lers
taillamp1243503taillamp
taillike1237863taillike
tailor63412503tai_l_or
taler56034863ta__le_r
talker103916223ta_lke_r
tallest7317093ta_llest
tallier72817213ta_llier
tangler83515073tangle_r
tattler73112213tattle_r
teller63519823t_elle_r
thriller1165553thrille_r
tiler56131023t_i_le_r
tilled74722953t_ille_d
tillers73418743t_illers
tilter63417693t_ilte_r
toiler63918283toi_le_r
toller63819443t_olle_r
trailer73015393trai_le_r
trailless935963trailless
trifler103912153trifle_r
trilled84116313trille_d
trillers83613493trillers
trillium1046203trillium
troller73913173trolle_r
tuille63012643tuille__
tuilles72411923tuille_s
twilled11398033twille_d
twirler10285203twirle_r
wailer93720323wai_le_r
willer94021063_wille_r

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.423422437.4
2DLD Change Limit146162786.92021121.7
3Display Results78780.0332363.6
 (SQL Overall)178691787.37624226.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.