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

202 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
matsahs123656(None) 
matsah1138231matsah_
matzahs2134481matzahs
masas75630412ma_sa_s
massas85116462massa_s
maths105624022mat__hs
matrass939402matrass
matzah2035962matzah_
matzas1749702matza_s
matzohs2134372matzohs
mitsvahs1642002mitsvahs
aahs716428563_a__ahs
almahs118611613_almahs
amahs107819063_a_mahs
amtracs1198883amtracs
assais6711963_assais
assays977903_assays
ataps76414833_at_aps
atlas55821583_atla_s
atmans84413963_atmans
atmas75721013_atma_s
attars64515313_attars
ayahs116813523_a_yahs
balsams11579013balsams
balsas86417523balsa_s
baths105922923bat__hs
caesars9410733caesars
casas75327843ca_sa_s
casbahs1436463casbahs
catnaps1197033catnaps
catspaws1543163catspaws
catsups1135343catsups
causals91411183causals
datchas1347423datchas
fatsoes10379423fatsoes
fatsos9389423fats_os
fatwas1249053fatwa_s
galahs105512673ga_lahs
ganjahs18104003ganjahs
gateaus866333gateaus
hallahs133912463hallahs
halvahs16417533halvahs
hamzahs24134373hamzahs
hansas94616043hansa_s
jarrahs1735453jarrahs
jetsams16124103jetsams
kasbahs1634363kasbahs
kashas133311903ka_shas
katas95922093kat_a_s
laths86022403lat__hs
lotahs9479873lot_ahs
maars74621633ma__ars
macaws1337023ma_caws
machs125722563ma__chs
madams11310943ma_dams
madcaps1435243madcaps
madras94316433madra_s
madrasahs15243853madrasahs
maenads1037373maenads
mafias113913573mafia_s
magians10310753magians
magmas115512503magma_s
maists85817573mais_ts
makars124612633ma_kars
malars85020683ma_lars
maltases1039693maltases
malthas1237913maltha_s
mamas95930773ma_ma_s
mambas125716243mamba_s
mammals10389273mammals
mammas94616403mamma_s
manas76240433ma_na_s
manats84623463ma_nats
mangas94122923manga_s
maniacs114313063maniacs
manias84029033mania_s
mannans93611523mannans
mannas85019803manna_s
mansard1049313mansard
mansards1148013mansards
manses84225513mans_es
mantas85725363manta_s
manteaus1036383manteaus
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantra_s
mantuas93410993mantua_s
manuals9311213manuals
maras75443293ma_ra_s
margays1337493margays
markas124717003marka_s
marrams11310123marrams
marsala939583marsala
marsalas1038253marsalas
marses84827113mars_es
marsh105320853mars_h_
marshal1238973marshal
marshals1337783marshals
marshes123615373marshes
marshy14558333mars_hy
martians103111613martians
masa65034723ma_sa__
masala8311813ma_sala
masalas9312053ma_salas
masers84623453ma_sers
mash96039403ma_s_h_
mashes115030003ma_shes
mashy136016503ma_s_hy
masks115320533ma_s_ks
masons83916513ma_sons
mass66044943ma_s__s
massa75518923massa__
massage1039893massage
massages1159883massages
masses85028713ma_sses
massifs1237743massifs
mastaba1146223mastaba
mastabahs1642973mastabahs
mastabas1246803mastabas
masters94628923masters
mastics112614783mastics
masts77035763ma_s_ts
match125621103mat_ch_
matches143219783matches
maters85032393mat_ers
mates75251363mat__es
mateys115610943mat_eys
math95437453mat__h_
matings104516213matings
matins84527783mat_ins
matless93014043matless
matres84522233mat_res
matrons93517633matrons
mats65460293mat___s
matters94421753matters
mattes85624533mat_tes
mattins93316143mattins
mattrass1045863mattrass
matts76829183mat__ts
matures9314303matures
matza16311813matza__
matzoh2035483matzoh_
matzos1749263mat_zos
mayas105924383ma_ya_s
maydays1634493maydays
mensas85115863mensa_s
mesas76823203m_esa_s
messans92710463messans
messiahs1343963messiahs
metals84520883met_als
meths105320233met__hs
mikvahs19162493mikvahs
missals93914423missals
missays124010253missays
mitsvah1542163mitsvah_
mitzvahs2541303mitzvahs
mollahs12328283mollahs
moolahs12347383moolahs
moths106021553mot__hs
mullahs12388733mullahs
musths11589483m_usths
mutases92012043mutases
mutuals937123mutuals
mynahs14416443m_ynahs
myths135911603myt__hs
nasals63312463na_sals
naysays1344123naysays
oaths86117313oat__hs
outsays102710403outsays
padshahs17113153padshahs
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
pardahs13289673pardahs
pariahs123812343pariahs
pashas115117063pa_shas
pastas85422873pasta_s
paths105521383pat__hs
patsies93919483patsies
petsais938433petsais
pitsaws1234993pitsaws
rajahs16497663ra_jahs
ratals64219583rat_als
ratans63819373rat_ans
ratbags1035763ratbags
rattans73411953rattans
rayahs12579193ra_yahs
salsas65316133salsa_s
sansars73313913sansars
sarsars73512143sarsars
satays94411683sat_ays
satraps95011643satraps
tarsals72512603tarsals
tatars64619793tat_ars
tatsois748373tatsois
tsars56717113__tsars
tussahs10335113tussahs
vassals1057953vassals
wallahs13409473wallahs
warsaws1335763warsaws
wataps11248683wat_aps
zaptiahs2242063zaptiahs

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 Filter1786911340270.440406115.9
2DLD Change Limit1340272026.76619808.9
3Display Results2022020.0762657.9
 (SQL Overall)1786912027.28224538.7
 
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.