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

143 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
maillots103747(None) 
maillot9312171maillot_
allots64019172_a_llots
ballots94116032ba_llots
mailless10248582mailless
maills84215282maill__s
mallets93318492ma_llets
mallows123714322ma_llows
marplots1245632marplots
matelots1047532matelots
melilots1046552melilots
millets94216842m_illets
aiglets84012913_aiglets
allods73615083_a_llods
allot54933873_a_llot_
allows94517683_a_llows
alloys94014563_a_lloys
bailors93212413bai_lors
bailouts1036613bailouts
ballets93719513ba_llets
ballons93916963ba_llons
ballot84624093ba_llot_
billets94516153_billets
billons93013363_billons
billows123611293_billows
brillos9369183brillo_s
callets93821703ca_llets
callous93516603ca_llous
carillons1146363carillons
diglots9299503_diglots
failles102914133faill_es
fallouts1137883fa_llouts
fallows133713973fa_llows
fillets103414753_fillets
fillos94415083_fillo_s
galiots82311323ga_liots
galipots1145213galipots
gallets83517403ga_llets
galliots9228683galliots
gallons83015953ga_llons
galloots9268963galloots
gallops103211653ga_llops
gallous82813953ga_llous
gallows113513513ga_llows
galoots82410793ga_loots
giglots9367863_giglots
halloas104318463ha_lloas
halloes104021523ha_lloes
halloos103716743ha_lloos
hallos95425103ha_llo_s
hallot95426783ha_llot_
halloth134111253ha_lloth
hallows134417393ha_llows
harlots103413293ha_rlots
hilloas104413553_hilloas
hilloes103815963_hilloes
hillos94618893_hillo_s
jailors14328753jai_lors
magalogs1245253magalogs
maggots1136563ma_ggots
magots9312363ma__gots
mailbags1343903mailbags
mailbox1853563mailbo_x
mailboxes2042713mailboxes
mailers94420333mai_lers
mailes84329113mai_l_es
mailings113011923mailings
maill74420793maill___
mailroom1244233mailroom
mailrooms1343763mailrooms
mails76037783mai_l__s
maintops1244403maintops
maists85817573mai__sts
malisons1048783malisons
mallees93315973ma_llees
mallet84433053ma_llet_
malleus92911313ma_lleus
mallow114014743ma_llo_w
malls76233433ma_ll__s
maloti8313213ma__loti
maltols939403ma_ltols
malts76331753ma__l_ts
manihots13126443manihots
manillas102611163manill_as
manilles102312603manill_es
mantlets104611203mantlets
marmots11311513ma_rmots
marplot1149673marplot_
martlets103310483martlets
mascots113910343ma_scots
matelot9411573matelot_
matelote1047603matelote
matelotes1146333matelotes
maxillas17227703maxill_as
medaillons1352353medaillons
melilot9311083melilot_
mellows123812233m_ellows
merlots92710123m_erlots
millers93621343m_illers
milles84526563m_ill_es
millet84030743m_illet_
millions101712433m_illions
mills75435053m_ill__s
milos75428013m_i_lo_s
milts75430713m_i_l_ts
misallots1144533misallots
mullets93614783m_ullets
nailsets834553nailsets
pallets93919303pa_llets
pallors9314363pa_llors
papillons1344093papillons
papillote1394093papillote
papillotes1493303papillotes
pavillons1443573pavillons
pillows122610123_pillows
pilots84018873_pi_lots
quillets17256823quillets
reallots837993reallots
rillets74216153_rillets
sailboats1145243sailboats
sailcloth1462573sailcloth
sailcloths1572493sailcloths
sailless82410373sailless
sailors73213723sai_lors
sallets73719653sa_llets
sallows103915553sa_llows
sandlots938293sandlots
shallots11319503shallots
skillets12226823skillets
tailcoats1144013tailcoats
tailles72516473taill_es
tailless8239083tailless
tailors73212393tai_lors
talipots1045623talipots
tallits73215993ta_llits
tallols73311363ta_llols
tallows103313743ta_llows
villous102810023_villous
wallets103914833wa_llets
wallops123410413wa_llops
wallows133613533wa_llows
willets104414323_willets
willows13299753_willows

Search took 9 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 Limit1461621438.07618098.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911438.54520911.8
 
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.