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 “achiotes” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
achiotes133900(None) 
achiote1239211achiote_
achieves1645522achieves
amniotes1036602amniotes
tachistes1466042tachistes
abioses9311493a_bioses
accidies1338043accidies
accretes1238113accretes
acetates102013063acetates
acetones10310033acetones
achenes12313493ach_enes
aches106132293ach___es
achier113914263achi__er
achiest12315193achi__est
achieve1545023achieve_
achieved1743713achieved
achiever1643843achiever
achievers1743433achievers
achillea1344103achillea
achilleas1443263achilleas
achiness1339703achiness
acidoses1136773acidoses
acnodes1037833ac_nodes
acolytes13168043acolytes
aconites10314353aconites
actioner1048663actioner
actioners1147723actioners
actions94218513actio_ns
activates1449683activates
actives12311523acti_ves
actuates10310313actuates
acuities10312453acuities
acutes83917723ac__utes
acylates1339743acylates
albites9313203albi_tes
amniote936963amniote_
antidotes1049533antidotes
aphides134711203aphi_des
aplites9314933apli_tes
archfoes1644993archfo_es
archines133815253archi_nes
archives16399553archi_ves
artistes83213343artistes
ascites9312603asci_tes
athletes1157883athletes
augites8312183augi_tes
aviates10313063a_viates
axites134913833a_xi_tes
azotes154312223a__zotes
brachiates1746353brachiates
cahoots1238473cahoot_s
capotes11314643_capotes
carioles10817073carioles
cenotes92814543_cenotes
chaoses124715123_chaoses
chayotes1636503_chayotes
chicles143512503_chicles
chides124620473_chi_des
chigoes1338353_chigoes
childes134211273_childes
chiles115425303_chi_les
chilies124218303_chilies
chimes134922573_chi_mes
chines115029173_chi_nes
chinones13510473_chinones
chints115117833_chint_s
chintses1337113_chintses
chintzes2235973_chintzes
chipotles1643793_chipotles
chirres123812253_chirres
chitons122611913_chitons
chits105424573_chi_t_s
chitter124112963_chitter
chitters133711173_chitters
chitties13310773_chitties
chives144317593_chi_ves
chivies153412853_chivies
choices142010613_choices
chokes154917383_ch_okes
chooses125717423_chooses
chores114828023_ch_ores
choses115825133_ch_oses
chotts113610993_ch_otts
chromes142914933_chromes
chutes114615773_ch_utes
cites74435593_c_i_tes
cotes76347843_c__otes
coyotes12410703_coyotes
dacites101114593dac_i_tes
echoes114715523ech_o_es
ichnites1345743ichnites
machetes1539633mach_etes
machinates1747323machinates
machines15312893machi_nes
ophites12310103ophi_tes
rachides141511223rachi_des
rachises131412413rachi_ses
rachitis1348353rachi_tis
schists1248543schist_s
schmoes14308543schmo_es
schnozes2244493schnozes
shotes95321913_sh_otes
tachismes1684223tachismes
tachiste1356213tachiste_
tachists1348183tachist_s
whites123919883_whi_tes

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.406440125.6
2DLD Change Limit1461621067.42019698.4
3Display Results1061060.0333212.1
 (SQL Overall)1786911067.85922737.1
 
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.