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

159 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
maillot931217(None) 
maillots1037471maillots
allot54933872_a_llot
ballot84624092ba_llot
hallot95426782ha_llot
mailbox1853562mailbox
maill74420792maill__
maills84215282maill_s
mallet84433052ma_llet
mallow114014742ma_llow
marplot1149672marplot
matelot9411572matelot
melilot9311082melilot
millet84030742m_illet
aiglet74224193_aiglet
aliyot93611713_aliyot
allod64418383_a_llod
allots64019173_a_llots
allow85420663_a_llow
alloy85519973_a_lloy
bailor83412603bai_lor
bailout9414133bailout
ballet84733973ba_llet
ballon84117493ba_llon
ballots94116033ba_llots
billet86029723_billet
billon83713833_billon
billow114111223_billow
brillo84211003brillo_
brillos9369183brillos
callet84536763ca_llet
callow114714663ca_llow
carillon1046963carillon
challot123613263challot
diglot83014333_diglot
faille93414743faill_e
failles102914133failles
fallout10313503fa_llout
fallow124713853fa_llow
fillet95027083_fillet
fillo84319783_fillo_
fillos94415083_fillos
galiot72322593ga_liot
galipot1049543galipot
gallet73630853ga_llet
galliot82214133galliot
gallon73715813ga_llon
galloot82814223galloot
gallop93311383ga_llop
galoot72719163ga_loot
giglot84013133_giglot
hallo85127553ha_llo_
halloa94918123ha_lloa
halloo95118973ha_lloo
hallos95425103ha_llos
halloth134111253ha_lloth
hallow124818323ha_llow
harlot94422803ha_rlot
hillo84721653_hillo_
hilloa94713033_hilloa
hillos94618893_hillos
jailor13418573jai_lor
magalog1144913magalog
maggot10311713ma_ggot
magot8326393ma__got
mail65543453mai_l__
mailbag1243923mailbag
maile75232223mai_l_e
mailed95326753mai_led
mailer84724183mai_ler
mailers94420333mailers
mailes84329113mai_les
mailing102923343mailing
mailless10248583mailless
mailman1137733mailman
mailmen1137273mailmen
mailroom1244233mailroom
mails76037783mai_l_s
mainly11411493mainl_y
maintop1135143maintop
maist75535683mai__st
malison939693malison
mall64639373ma_ll__
malled94626113ma_lled
mallee84525593ma_llee
mallei84414633ma_llei
mallets93318493ma_llets
mallows123714323ma_llows
malls76233433ma_ll_s
maloti8313213ma__loti
malt66254813ma__l_t
maltol8310843ma_ltol
manihot121112053manihot
manilla93012473manill_a
manillas102611163manillas
manille92613273manill_e
manilles102312603manilles
mantlet93620993mantlet
marmot10318743ma_rmot
marplots1245633marplots
martlet93419153martlet
mascot104016073ma_scot
matelote1047603matelote
matelots1047533matelots
matzot17710983ma_tzot
maxilla16248193maxill_a
maxillae17256723maxillae
maxillas17227703maxillas
medaillon1242653medaillon
melilots1046553melilots
mellow114112223m_ellow
merlot83217613m_erlot
mikvot1556763m_ikvot
mill66541483m_ill__
mille75029133m_ill_e
milled94326173m_illed
miller84625413m_iller
milles84526563m_illes
millets94216843m_illets
million91813143m_illion
mills75435053m_ill_s
milo65536103m_i_lo_
milos75428013m_i_los
milt65455813m_i_l_t
misallot1047003misallot
mislit83019693m_islit
mullet84126823m_ullet
nailset7311973nailset
pallet84232653pa_llet
pallor8313673pa_llor
papillon1244723papillon
papillote1394093papillote
pavillon1344053pavillon
pillow113110573_pillow
pilot77435063_pi_lot
quillet162713233quillet
reallot7312133reallot
rillet64828853_rillet
sailboat1047693sailboat
sailcloth1462573sailcloth
sailor63113753sai_lor
sallet63734543sa_llet
sallow94315753sa_llow
sandlot8311693sandlot
shallot103614133shallot
skillet113512153skillet
tailcoat1046853tailcoat
taille63116923taill_e
tailles72516473tailles
tailor63412503tai_lor
talipot949723talipot
tallit63422733ta_llit
tallol63612223ta_llol
tallow93714203ta_llow
wallet93327093wa_llet
wallop113310293wa_llop
wallow123913513wa_llow
willet95124833_willet
willow12369693_willow

Search took 7 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.390458182.1
2DLD Change Limit1340271596.19021652.2
3Display Results1591590.0602650.0
 (SQL Overall)1786911596.64026911.3
 
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.