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

253 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
madtom113802(None) 
madtoms1236921madtoms
atom67824522_a_tom
fantom112110802fantom
madam10316222mad_am
maltol8310842maltol
actor71116083_actor
adeem8311803_adeem
adios65822863_adios
ado49146873_ad_o_
ados57633513_ad_os
adytum1243733_adytum
alto47831263_alto_
altos55822953_altos
amadou977613amad_ou
amatol838693amatol
atoms76817563_a_toms
atomy107415193_a_tomy
atop66124753_a_top
auto47432083_auto_
autos56523323_autos
axiom143913593_axiom
bantam10314063bantam
baton75822423ba_ton
bottom1048723bottom
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
captor104914603captor
carom95025563ca_rom
carrom10513403carrom
carton84522663carton
cartop104213563cartop
castor84418533castor
custom104010273custom
dadgum1134583dadgum
dado67126333dad_o_
dados75522433dad_os
dalton7311273dalton
dato56129943da_to_
datos65222783da_tos
datto65416423datto_
dattos74311903dattos
datum8310633da_tum
diatom939453diatom
dom69752443__d_om
doom76430073__doom
factor11911463factor
fado87226463fad_o_
fados95620733fad_os
fandom122110893fandom
fantod102010033fantod
fantoms12189153fantoms
fathom1437473fathom
gadjo1436913gadjo_
gator64416043ga_tor
hadron102913753hadron
hansom11219153hansom
hardtop1345053hardtop
idiom899963_idiom
jato115822683ja_to_
jatos125116823ja_tos
lactam10310943lactam
ladron73413323ladron
laptop1076813laptop
macho126120153macho_
machos135217493machos
macon94519953ma_con
macro94718173macro_
macron103615673macron
macros104017013macros
mad68958713mad___
madame1139853madame
madams11310943madams
madcap1336333madcap
madded113513553madded
madden103912523madden
madder103515593madder
made75440243mad__e
madly115218133mad_ly
madman113712383madman
madmen113511743madmen
madras94316433madras
madre85720173mad_re
madres93718183madres
madrona10288703madrona
madrone102812663madrone
madrono10288743madrono
mads76845373mad__s
maduro936983maduro
maduros1036303maduros
madwoman1643693madwoman
madwomen1644793madwomen
madwort13611363madwort
madzoon1996063madzoon
maftir1136493maftir
maggot10311713maggot
magnum1136733magnum
magot8326393ma_got
magots9312363magots
mahoe10315573ma_hoe
mahzor2035113mahzor
maihem1366213maihem
maim85831493ma__im
maintop1135143maintop
major145212923ma_jor
mako105622363ma_ko_
makos116518363ma_kos
mallow114014743mallow
malm85129983ma__lm
maloti8313213maloti
malt66254813malt__
malted94819863malted
maltha1137513maltha
maltols939403maltols
maltose939793maltose
malts76331753malt_s
malty106721703malt_y
mambo115215743mambo_
mambos125414493mambos
mammon939643mammon
mandator1148183mandator
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
manito8518693manito_
manitos9314053manitos
manitou938463manitou
mano66536813ma_no_
manor78023933ma_nor
manos74933623ma_nos
manta75629913mant_a
mantas85725363mantas
mantel84317973mantel
mantes84430783mantes
mantic104120903mantic
mantid93820383mantid
mantis83926033mantis
mantle84420923mantle
mantra84116093mantra
mantram114011603mantram
mantua84412023mantua
marmot10318743marmot
maroon83118203maroon
marram10313883marram
marron83717543marron
marrow112812603marrow
mart66865983mart__
marted94425213marted
marten84518263marten
martin84122523martin
marts77442233mart_s
martyr1135693martyr
mascon103612743mascon
mascot104016073mascot
mason74820183ma_son
mast65959963mast__
masted94025803masted
master84831343master
mastic103119173mastic
mastix152310513mastix
mastoid10711233mastoid
masts77035763mast_s
mat58083943ma_t__
match125621103ma_tch
mate65154223ma_t_e
mated85537783ma_ted
mater74438863ma_ter
mates75251363ma_tes
matey107022663ma_tey
math95437453ma_t_h
maths105624023ma_ths
matin75132853ma_tin
matron83918313matron
mats65460293ma_t_s
matt65752663ma_t_t
matte75626843ma_tte
matted94521413matted
matter84325343matter
mattes85624533mattes
mattin84416633mattin
mattock1535823mattock
mattoid1079283mattoid
matts76829183ma_tts
matza16311813ma_tza
matzo16312893ma_tzo
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
maut65448453maut__
mauts75927193maut_s
maxim165216003ma_xim
mayhem1644923mayhem
mayo96524303ma_yo_
mayor106616623ma_yor
mayos105521933ma_yos
maypop1565143maypop
meadow1237403mead_ow
medium113711623medium
melton8311553melton
mentor8414363mentor
mentum104511713mentum
metol75917813m_etol
midterm12316013midterm
midtown1343673midtown
modem103717143mod_em
molto75619603molto_
mom78853163m___om
motor75317293m_otor
motto76119513motto_
mottos84615243mottos
mouton8410853mouton
mudroom1244953mudroom
muton73817003m_uton
mutton8510453mutton
myotome1445483myotome
panto76129413panto_
pantos85222743pantos
pantoum1138703pantoum
parton84720993parton
pastor84817483pastor
phantom1436693phantom
radio64922493radio_
radios74018673radios
radium93513293radium
radome9511873rad_ome
radon64620503rad_on
ragtop936683ragtop
random92513553random
ransom82410943ransom
raptor83912823raptor
rato45436973ra_to_
ratos55528763ra_tos
ratton64116123ratton
redtop937973redtop
sadism94113493sadism
santo56227283santo_
santol64515243santol
santos64421833santos
sartor6313883sartor
satem76021463sa_tem
smalto84410283smalto_
smaltos9408193smaltos
sodom8814913sod_om
tanto55724943tanto_
tattoo6310973tattoo
tautog765713tautog
tom514358053___tom
vagrom1235943vagrom
varoom11411413varoom
wadmol1234053wadmol
wanton94413813wanton

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162535.98318839.4
3Display Results2532530.0803162.5
 (SQL Overall)1786912536.45627678.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.