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

164 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
mazumas203462(None) 
mazuma1935601mazuma_
gazumps2131872gazumps
maculas113114012maculas
macumbas1653002macumbas
magmas115512502ma_gmas
mamas95930772ma__mas
mammas94616402ma_mmas
mazurkas2372372mazurkas
mezuzas1743232mezuzas
mizunas1843692mizunas
abomas101113583_abomas
agamas97413443_agamas
agmas85919873_a_gmas
ajugas1435263_ajugas
almas76629773_a_lmas
alums75720603_alum_s
amas67746293_a__mas
animas84418723_animas
aquas142412613_aqu_as
aromas81018613_aromas
arums75517833_arum_s
atmas75721013_a_tmas
auras55932553_a_uras
azukis1963733_azukis
azures15510183_azures
caeomas1138393caeomas
camas96333523ca__mas
canulas9312853canulas
datums936353datum_s
daturas838763daturas
doumas95314813_doumas
dumas85420433__dumas
eczemas2063143eczemas
fanums1137263fanum_s
faunas94013633fa_unas
gamas85431353ga__mas
gammas115714693ga_mmas
gaums86217073ga_um_s
gazump2032453gazum_p
halmas117017893ha_lmas
hanuman1237123hanuman
hanumans1344943hanumans
hazmat20312263haz_mat
hazmats2136603haz_mats
imaums10106293ima_um_s
jazzman2442553jazzman
kahunas1473953kahunas
karmas123013733ka_rmas
lacunas9138173lacunas
lagunas8156823lagunas
lamas75532793la__mas
larums83610533larum_s
lauras63414333la_uras
lazulis1634903lazulis
loumas84812333_loumas
lumas75622913__lumas
macula103013673macula_
maculae113412863maculae
macular113011943macular
macules114015133macules
macumba1573043macumba
madames12310063madames
madams11310943madam_s
madman113712383ma_dman
madras94316423ma_dras
maduros1036283maduros
maffias15327283maffias
mafias113913573ma_fias
magma104513573ma_gma_
magnums1234683magnum_s
magueys1333943magueys
magus85318753magu__s
mahatmas1543863mahatmas
mailman1137733mailman
maims96321783ma_im_s
mainmast1245863mainmast
makuta1236393makuta_
malms95021553ma_lm_s
malthas1237913malthas
mama86231583ma__ma_
mambas125716243ma_mbas
mamma86317913ma_mma_
mammae94613213ma_mmae
mammal95112753ma_mmal
mammals10389273ma_mmals
mananas93414733mananas
manas76240423ma__nas
mangas94122923ma_ngas
manias84029033ma_nias
manilas93915873manilas
mannas85019803ma_nnas
mantas85725363ma_ntas
mantras93815863mantras
mantuas93410993mantuas
manual8313463manu_al
manuals9311213manuals
manumit1149573manumit
manumits1246003manumits
manures9313353manures
manus75924923manu__s
maquilas1944033maquilas
maquis17249483maqu_is
maracas11313773maracas
maras75443283ma__ras
marimbas1444363marimbas
marinas93519373marinas
markas124717003ma_rkas
markkas12356083markkas
marrams11310123marrams
masalas9312053masalas
masas75630413ma__sas
massas85116463ma_ssas
matures9314303matures
matzas1749703ma_tzas
mauds85519273ma_u_ds
mauls76524953ma_u_ls
maumet103518883ma_umet
maumets11369693ma_umets
maunds9519653ma_unds
mauts75927193ma_u_ts
mauves113811553ma_uves
maxima17568633maxima_
maximal18347093maximal
maximals19325223maximals
maxims17399673maxim_s
mayas105924383ma__yas
mazards1937703mazards
mazers173917093maz_ers
mazes165632173maz__es
mazourkas2441253mazourkas
mazurka2272873mazurka
medusas1036213medusas
metumps1334133metumps
mezuza1643533mezuza_
mezuzah2041973mezuzah
mezuzahs2141353mezuzahs
miasmas1167743miasmas
mizuna1734303mizuna_
mommas94110653m_ommas
morulas959703morulas
mumms85513153m__umms
mumps115619103m__umps
mums85732773m__um_s
mumus95517283m__umus
muras75329563m__uras
myomas1338293m_yomas
myxomas2153903myxomas
oakums1264153oakum_s
pajamas18278153pajamas
panamas113112753panamas
paruras9310533paruras
pneumas1145103pneumas
pumas95121563__pumas
radulas839583radulas
ranulas7311773ranulas
satsumas1043573satsumas
saunas63915433sa_unas
strumas9419833strumas
talukas11316213talukas
taramas9612693taramas
tazzas1436273taz_zas
traumas938583traumas
valutas1036533valutas

Search took 9 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.1561145455.1
2DLD Change Limit1340271647.84317088.7
3Display Results1641640.0463565.2
 (SQL Overall)1786911648.04522211.4
 
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.