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

186 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
matzoh203548(None) 
matzah2035961matzah
matzo16312891matzo_
matzohs2134371matzohs
matzos1749261matzos
matzot17710981matzot
matzoth2144331matzoth
mahzor2035112mahzor
match125621102mat_ch
math95437452mat__h
matron83918312matron
matsah1138232matsah
matza16311812matz_a
matzahs2134482matzahs
matzas1749702matzas
matzoon1896472matzoon
amatol838693amat_ol
amazon1736833amazon
atom67824523_at_om
atop66124753_at_op
azo128233393_a_zo_
azon135725053_a_zon
azoth17389903_a_zoth
batboy1387533batboy
batch124620103bat_ch
bath95940083bat__h
bathos116215633bathos
baton75822423bat_on
bazoo163815673ba_zoo
catch125120373cat_ch
cation83925503cation
dato56129943dat_o_
datos65222783dat_os
datto65416423datto_
dattos74311903dattos
eath75735663eat__h
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
gator64416043gat_or
gazoo153112873ga_zoo
hamzah23135563hamzah
hatbox1835133hatbox
hatch135719593hat_ch
hath105933913hat__h
jato115822683jat_o_
jatos125116823jat_os
kation104315683kation
kazoo183311533ka_zoo
latch104620463lat_ch
lath76640383lat__h
latish92416173latish
mach116134483ma__ch
macho126120153macho_
machos135217493machos
machzor2344263machzor
macon94519953ma_con
macro94718173macro_
macron103615673macron
macros104017013macros
madtom1138023madtom
madzoon1996063madzoon
maggot10311713maggot
magot8326393ma_got
mahoe10315573ma_hoe
mahzors2135123mahzors
maize164618563maiz_e
maizes175115733maizes
major145212923ma_jor
mako105622363ma_ko_
makos116518363ma_kos
mallow114014743mallow
maltol8310843maltol
mambo115215743mambo_
mambos125414493mambos
mammon939643mammon
mammoth1344983mammoth
mamzer19459833mamzer
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
mano66536813ma_no_
manor78023933ma_nor
manos74933623ma_nos
march125622893ma_rch
marish114319053marish
marmot10318743marmot
maroon83118203maroon
marron83717543marron
marrow112812603marrow
marsh105320853ma_rsh
mascon103612743mascon
mascot104016073mascot
mash96039403ma__sh
mason74820183ma_son
mat58083943mat___
matador1066253matador
mate65154223mat__e
mated85537783mat_ed
matelot9411573matelot
mater74438863mat_er
maters85032393maters
mates75251363mat_es
matey107022663mat_ey
mateys115610943mateys
maths105624023mat_hs
matier84321523matier
matin75132853mat_in
mating94832913mating
matins84527783matins
matres84522233matres
matrix1539853matrix
matrons93517633matrons
mats65460293mat__s
matsahs1236563matsahs
matt65752663mat__t
matte75626843mat_te
matted94521413matted
matter84325343matter
mattes85624533mattes
mattin84416633mattin
mattock1535823mattock
mattoid1079283mattoid
matts76829183mat_ts
mature8313473mature
matzoons19105083matzoons
mayo96524303ma_yo_
mayor106616623ma_yor
mayos105521933ma_yos
maypop1565143maypop
maze155434983ma_z_e
mazed175523873ma_zed
mazer165722423ma_zer
mazes165632173ma_zes
mazy186419703ma_z_y
metazoa1845543metazoa
meteor84910073meteor
meth95827843met__h
method1239033method
metol75917813met_ol
metro74718803metro_
metros84217803metros
mezzo1537433mezzo_
mezzos1635053mezzos
mitzvah2441783mitzvah
mitzvoth2551413mitzvoth
moth96731333mot__h
motion85217553motion
motmot10311073motmot
motor75317293mot_or
motto76119513motto_
mottos84615243mottos
mozo157719743m_ozo_
mozos165516333m_ozos
mutch125016173mut_ch
muton73817003mut_on
mutton8510453mutton
myth126715433myt__h
mythoi14417143mythoi
mythos14398473mythos
natch105018223nat_ch
nation64322803nation
natron64116023natron
oath76132153oat__h
patch125221223pat_ch
path99134913pat__h
pathos115516693pathos
patio74426353patio_
patios85221783patios
patrol83213023patrol
patron84018043patron
patzer173111643patzer
ratch104221363rat_ch
rath76037663rat__h
ratio55227583ratio_
ration64226013ration
ratios64922673ratios
rato45436973rat_o_
ratoon64417373ratoon
ratos55528763rat_os
ratton64116123ratton
razor143012603ra_zor
tatsoi637263tatsoi
tattoo6310973tattoo
watch135617063wat_ch
wazoo173011173wa_zoo

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.376475242.0
2DLD Change Limit1127161865.72019705.6
3Display Results1861860.0434325.6
 (SQL Overall)1786911866.13929107.5
 
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.