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

227 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
matzah203596(None) 
matsah1138231matsah
matza16311811matza_
matzahs2134481matzahs
matzas1749701matzas
matzoh2035481matzoh
hamzah23135552hamzah
match125621102mat_ch
math95437442mat__h
matsahs1236562matsahs
matzo16312892matz_o
matzohs2134372matzohs
matzos1749262matzos
matzot17710982matzot
matzoth2144332matzoth
mitzvah2441782mitzvah
aah616252963_a__ah
almah106917253_almah
amah98927483_a_mah
amtrac10109123amtrac
atap66722453_at_ap
atlas55821583_atlas
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
attach11118393_attach
attar56516693_attar
ayah108022993_a_yah
azan136521783_a_zan
baiza164813223baiza_
baizas173810823baizas
banzai1737653banzai
batch124620103bat_ch
bateau8810563bateau
bath95940083bat__h
batman105214063batman
bazar163816003ba_zar
casbah1337903casbah
catch125120373cat_ch
catnap1098383catnap
data56026653dat_a_
datcha1266563datcha
eath75735663eat__h
fatal84819373fat_al
fatwa1168063fatwa_
fatwas1249053fatwas
galah95917623ga_lah
ganjah17145493ganjah
gateau778103gateau
gazar154612983ga_zar
hallah124115403hallah
halvah15499833halvah
hamza19139773hamza_
hamzahs24134373hamzahs
hamzas20119013hamzas
hatch135719593hat_ch
hath105933913hat__h
hazan173813613ha_zan
hazzan17236803hazzan
hutzpah2441803hutzpah
huzzah2044423huzzah
jarrah1636683jarrah
kasbah1535183kasbah
kata85626023kat_a_
katas95922093kat_as
latch104620463lat_ch
lath76640383lat__h
latish92416173latish
lazar144113643la_zar
lotah85315853lot_ah
maar66025053ma__ar
macaw12311763ma_caw
mach116134473ma__ch
madam10316223ma_dam
madcap1336333madcap
madman113712383madman
madras94316423madras
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magma104513573magma_
magmas115512503magmas
mahzor2035113mahzor
maize164618563maiz_e
maizes175115733maizes
makar115614973ma_kar
malar76424443ma_lar
maltha1137503maltha_
malthas1237913malthas
mama86231583ma_ma_
mamas95930773ma_mas
mamba116317523mamba_
mambas125716243mambas
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammas94616403mammas
mamzer19459833mamzer
mana65341943ma_na_
manas76240423ma_nas
manat76039983ma_nat
manga85026193manga_
mangas94122923mangas
mania75634143mania_
maniac103917973maniac
manias84029033manias
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
manta75629903manta_
mantas85725363mantas
manteau937863manteau
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mantua84412023mantua_
mantuas93410993mantuas
manual8313463manual
mara67444563ma_ra_
maras75443283ma_ras
march125622893ma_rch
margay12310593margay
maria75032883maria_
marish114319053marish
marka114620793marka_
markas124717003markas
marram10313883marram
marsh105320853ma_rsh
martial92415413martial
martian93514683martian
masa65034713ma_sa_
masas75630413ma_sas
mash96039393ma__sh
massa75518923massa_
massas85116463massas
mastabah1554023mastabah
mat58083933mat___
mate65154213mat__e
mated85537783mat_ed
mater74438863mat_er
maters85032383maters
mates75251363mat_es
matey107022663mat_ey
mateys115610943mateys
maths105624023mat_hs
matier84321523matier
matin75132853mat_in
matinal9312603matinal
mating94832913mating
matins84527783matins
matrass939393matrass
matres84522233matres
matrix1539833matrix
matron83918313matron
mats65460283mat__s
matt65752653mat__t
matte75626843mat_te
matted94521413matted
matter84325343matter
mattes85624533mattes
mattin84416633mattin
matts76829183mat_ts
mature8313463mature
matzoon1896473matzoon
maya95824583ma_ya_
mayan105616903ma_yan
mayas105924383ma_yas
mayday1535873mayday
mayhap1635233mayhap
mazard1838763ma_zard
maze155434973ma_z_e
mazed175523873ma_zed
mazer165722423ma_zer
mazes165632173ma_zes
mazy186419693ma_z_y
mazzard1844463mazzard
meatal84114733meat_al
meatman1137903meatman
meta65932413met_a_
metal75427383met_al
meth95827843met__h
mezuzah2041973mezuzah
mikvah18143473mikvah
mirza16410443mirza_
mirzas1738173mirzas
mitral81314323mitral
mitsvah1542163mitsvah
mitzvahs2541303mitzvahs
mollah11319453mollah
moolah11409193moolah
moth96731333mot__h
mullah113710733mullah
mutch125016173mut_ch
mutual838503mutual
mynah13569563m_ynah
myth126715433myt__h
natal53921493nat_al
natch105018223nat_ch
oath76132153oat__h
pardah123412823pardah
pariah114320583pariah
patch125221223pat_ch
path99134913pat__h
patzer173111643patzer
rajah155711423ra_jah
ratal55025113rat_al
ratan53722663rat_an
ratbag956563ratbag
ratch104221363rat_ch
rath76037663rat__h
rattan63613603rattan
rayah116013503ra_yah
satay84718463sat_ay
satrap86212553satrap
tarzan152910753tarzan
tatar56122063tat_ar
tazza1338083tazza_
tazzas1436273tazzas
tzar136315373__tzar
wallah124011993wallah
watap102111673wat_ap
watch135617063wat_ch
zanza1378703zanza_
zanzas1487053zanzas
zaptiah2144293zaptiah

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.1401276364.3
2DLD Change Limit1127162276.42317548.8
3Display Results2272270.0762986.8
 (SQL Overall)1786912276.63926915.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.