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

275 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
mantlets10461120(None) 
gantlets9308901gantlets
mantelets1176811mantelets
mantles94820701mantle_s
mantlet93620991mantlet_
martlets103310481martlets
anklets114310412_anklets
antlers74014742_antlers
cantles94721412cantle_s
gantlet83616242gantlet_
gauntlets1042872gauntlets
hantles104117512hantle_s
mallets93318492ma_llets
manchets15269572manchets
maneless102812342maneless
manglers113311902manglers
mangles104021462mangle_s
manless93012932man_less
mantelet10613822mantelet_
mantels94515042mant_els
mantes84430782mant_e_s
mantle84420922mantle__
mantled104113392mantle_d
martlet93419152martlet_
mastless102610022mastless
matless93014042ma_tless
pantalets1147672pantalets
partlets102811512partlets
plantlets1145012plantlets
tartlets8289662tartlets
aglets73915683_a_glets
aiglets84012913_aiglets
amulets939923_amulets
analects1047703_analects
aneles64626293_anele_s
anglers84014823_anglers
angles74426703_angle_s
ankles104818383_ankle_s
anklet105618733_anklet_
annulets845813annulets
anoles64827433_anole_s
antes56334323_ant_e_s
anthems12309423_anthems
anthers103715203_anthers
antler64615553_antle_r
antres65021003_antre_s
applets115710063_applets
armlets94610063_armlets
artless73712513_artless
auklets11298573_auklets
ballets93719513ba_llets
bangles103617413bangle_s
bannets94013843ban_nets
banquets1935433banquets
banters94623113bant_ers
banties94324763bantie_s
battlers104110973battlers
battles94517683battle_s
bractlets1344753bractlets
cablets114216343ca_blets
callets93821703ca_llets
camlets114314623ca_mlets
candlers114214103candlers
candles104422343candle_s
canteens1038573canteens
canters94827733cant_ers
cantle84522153cantle__
capelets1268603capelets
caplets114914523ca_plets
castles94917733castle_s
cutlets94113653_cutlets
dandlers103912053dandlers
dandles94218533dandle_s
danglers103610593danglers
dangles93618423dangle_s
dartles84014133dartle_s
dauntless1033663dauntless
eaglets84111663ea_glets
fangless1237663fangless
fanjets1734803fan_jets
fantasts1147113fantasts
fartleks1533963fartleks
fatless103212203fa_tless
flatlets1147373flatlets
frontlets1244233frontlets
gallets83517403ga_llets
gannets83811443gan_nets
gantleted1144393gantleted
gauntlet955903gauntlet_
gentles83714343gentle_s
gentlest93410573gentlest
haltless11308443haltless
hamlets123211403ha_mlets
handlers124014143handlers
handles114020653handle_s
handless123512063handless
handsets12258343handsets
hantle94318203hantle__
harslets1137833harslets
haslets102510863ha_slets
hatless103813443ha_tless
inlets63915573_in_lets
janglers16319373janglers
jangles154015683jangle_s
kanteles1238123kanteles
kinglets13318583kinglets
lancelets1144833lancelets
lancets93411163lan_cets
landlers94312833landlers
landless94011173landless
langleys1245103langleys
languets987243languets
lintless82710013lintless
mackles154415753mackle_s
macles107023223ma_cle_s
macules114015133macule_s
maglevs1334693ma_glevs
magnets10311143ma_gnets
mailers94420333ma_ilers
mailes84329113ma_ile_s
mailless10248583mailless
maillots1037473maillots
males75049793ma__le_s
mallees93315973ma_llees
mallet84433053ma_llet_
malleus92911313ma_lleus
malteds10377603malt_eds
maltiest102916193maltiest
maltreats1145223maltreats
malts76331753ma__l_ts
mammets103911113ma_mmets
manacles1239523manacle_s
managers112911003managers
manages103418963manage_s
manatees10310423manatees
manats84623463man__ats
manches143818623manche_s
manchet143317783manchet_
mandates11314093mandates
mandrels1137313mandrels
maneges103612143manege_s
manes76648963man__e_s
mangels103614493man_gels
mangers103521263man_gers
manges94628943man_ge_s
mangiest112815903mangiest
mangle93921323mangle__
mangled113615263mangle_d
mangler103215643mangle_r
mangoes104316133mangoe_s
manholes13311183manhole_s
manhunts1344043manhunts
manifest1339503manifest
manifests1444123manifests
manihots13126443manihots
manilas93915873manil_as
manillas102611163manillas
manilles102312603manilles
maniples12269423maniple_s
manliest102314943manliest
manners93417833man_ners
mannites10312613mannites
manses84225513man_se_s
mantas85725363mant__as
manteau937863mant_eau
manteaus1036383manteaus
mantel84317973mant_e_l
mantids103113623mant_ids
mantillas1147043mantillas
mantis83926033mant__is
mantises10317923mantises
mantling112012613mantling
mantlings12207233mantlings
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mant_ras
mantuas93410993mant_uas
manumits1246003manumits
manurers1037593manurers
manures9313353manure_s
maples104819423ma_ple_s
marblers12319233marblers
marbles114516653marble_s
markets133314033ma_rkets
marplots1245633marplots
martens93714953mart_ens
martinets1138883martinets
massless10277113massless
masters94628923mast_ers
mateless102711293mateless
matelots1047533matelots
maters85032393ma_t_ers
mates75251363ma_t_e_s
mateys115610943ma_t_eys
matiest92522453ma_tiest
matres84522233ma_tre_s
matters94421753ma_tters
mattes85624533ma_tte_s
mattress1036533mattress
matts76829183ma_t__ts
maulers94213303ma_ulers
maumets11369693ma_umets
meatless103410863meatless
mentees93214503ment_ees
mettles94115023mettle_s
millets94216843m_illets
minarets1048843minarets
mindless11319443mindless
mindsets1135683mindsets
minglers113011293minglers
mingles103719003mingle_s
minters93822473mint_ers
mintiest103217143mintiest
minuets9259853min_uets
montes84226933mont_e_s
moonlets10247473moonlets
motets84216193m_ot_ets
motleys1235683m_otleys
mottlers10388183mottlers
mottles93415803mottle_s
mullets93614783m_ullets
myrtles1235733myrtle_s
nutlets74111253_nutlets
outlets73616363_outlets
palets85122313pa__lets
pallets93919303pa_llets
paneless102611763paneless
pantalet10415903pantalet_
panthers13510783panthers
panties94230933pantie_s
pantiles103617153pantile_s
partlet92720363partlet_
pastless102411203pastless
pintles94118723pintle_s
plantlet10310013plantlet_
rankles113114543rankle_s
rankless12268233rankless
ranters73323643rant_ers
rattlers83510293rattlers
rattles73217303rattle_s
ringlets92910233ringlets
rootlets8308653rootlets
rundlets9307363rundlets
runlets73310773run_lets
sallets73719653sa_llets
saltless8259343saltless
samlets93813553sa_mlets
sandless93212343sandless
sandlots938293sandlots
singlets93611473singlets
tablets94714383ta_blets
tactless10288463tactless
taintless935733taintless
tanglers92911973tanglers
tangles83920043tangle_s
tankless12267823tankless
tartlet72218483tartlet_
tattlers8369693tattlers
tattles73616283tattle_s
tentless8229843tentless
tintless8239863tintless
tonlets73212503ton_lets
valets93715623va__lets
varlets10411573va_rlets
ventless11249053ventless
wallets103914833wa_llets
wanglers123310033wanglers
wangles113416933wangle_s
wanters104420093want_ers
wartless11279923wartless
wattles103814073wattle_s
wattless11268723wattless
wavelets1436153wavelets
winglets12299593winglets
wintles103414983wintle_s

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 Limit1461622756.54622328.4
3Display Results2752750.1102500.0
 (SQL Overall)1786912757.07925242.4
 
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.