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

339 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
mantuas9341099(None) 
mantas85725361mant_as
mantras93815861mantras
mantua84412021mantua_
antas55432032_ant_as
cantus85117762cantu_s
malthas1237912malthas
mananas93414732mananas
manas76240432man__as
mangas94122922man_gas
manias84029032man_ias
manilas93915872manilas
manitus9310922manitu_s
mannas85019802man_nas
manta75629912mant_a_
manteau937862manteau
manteaus1036382manteaus
mantels94515042mantels
mantes84430782mant_es
mantids103113622mantids
mantis83926032mant_is
mantles94820702mantles
mantra84116092mantra_
mantram114011602mantram
mantrams12288962mantrams
mantrap11379822mantrap
mantraps12298062mantraps
manual8313462man_ual
manuals9311222man_uals
manus75924932man_u_s
matzas1749702ma_tzas
santurs7310762santurs
tantras73112092tantras
yantras10259002yantras
actual8311023_actual
amanitas1048533amanitas
amentias1039413amentias
amiantus1044383amiantu_s
anabas8314083_anabas
anas46649863_an__as
angas65827983_an_gas
animas84418723_animas
ankus91410683_anku_s
anlas55626933_an_las
annas55824883_an_nas
annual64710703_annual
annuals7388193_annuals
annuls64711733_annuls
anoas57226493_an_oas
anta46839583_ant_a_
antae56828293_ant_ae
antes56334323_ant_es
antiar6317173_antiar
antiars7314623_antiars
antics84621453_antics
antis55033313_ant_is
antra56521923_antra_
antral65719413_antral
antres65021003_antres
antrums969173_antrums
ants47243473_ant__s
anus47131113_an_u_s
aquas142412613_a_quas
atlas55821583_a_tlas
atmas75721013_a_tmas
bananas93312223bananas
bandas95120543ban_das
bantam10314063bant_am
bantams1149063bantams
banters94623113banters
banties94324763banties
battues94610193battues
cactus104912233cactu_s
canchas143212403canchas
canfuls1248423canfuls
cangues10611823cangues
cannas84518403can_nas
cannulas1037583cannulas
canolas9313993canolas
cantal84122033cant_al
cantalas104013523cantalas
cantals93919573cantals
cantatas103410093cantatas
canters94827733canters
canthal12410053canthal
canthus1248713canthus
cantinas102713783cantinas
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973cant_os
cantrap113310283cantrap
cantraps12319113cantraps
cants77036943cant__s
canulas9312853canulas
canvas113813333can_vas
centas85020703cent_as
centums11398783centums
contras93015623contras
datums936353da_tums
daturas838783da_turas
factual1246723factual
fanegas1145713fanegas
fangas105017193fan_gas
fantasm1236593fant_asm
fantast10311703fant_ast
fantasy1336153fant_asy
fantods11177623fantods
fantoms12189153fantoms
fanums1137263fan_ums
fatwas1249053fa_twas
gangues9149753gangues
ganjas14149113gan_jas
hangups1364813hangups
hansas94616043han_sas
hantles104117513hantles
hants86335403hant__s
juntas134210503junt_as
kanakas10327213kanakas
kanas95326913kan__as
kantar10311153kant_ar
kantars11310033kantars
kanzus1944603kanzu_s
katas95922093ka_t_as
landaus8310343landaus
langues81211913langues
langurs889103langurs
lantanas838263lantanas
maculas113114023maculas
madras94316433ma_dras
madtoms1236923madtoms
maffias15327283maffias
mafias113913573ma_fias
maftirs1236043maftirs
magentas1137923magent_as
magmas115512503ma_gmas
magnums1234683magnums
magus85318753ma_gu_s
mahatmas1543863mahatmas
mahouts1237143mahouts
maintops1244403maintops
majaguas1842843majaguas
makeups1533603makeups
makuta1236393makuta_
maltase938903malt_ase
malteds10377603malteds
maltha1137513maltha_
maltols939403maltols
malts76331753malt__s
mamas95930773ma__mas
mambas125716243ma_mbas
mamluks1543313mamluks
mammas94616403ma_mmas
mana65341963man__a_
manages103418963manages
manana84816073manana_
manat76039993man__at
manatees10310423manatees
manats84623463man_ats
manches143818623manches
mandalas1139443mandalas
mandolas1139133mandolas
maneges103612143maneges
manes76648963man__es
manful11610213manfu_l
manga85026203man_ga_
mangels103614493mangels
mangers103521263mangers
manges94628943man_ges
mangles104021463mangles
mangoes104316133mangoes
mangos94319333man_gos
manhunt1247073manhunt
manhunts1344043manhunts
mania75634153man_ia_
maniac103917973man_iac
maniacs114313063maniacs
manics103919933man_ics
manila84518303manila_
manillas102611163manillas
maniocas12298473maniocas
maniocs113611443maniocs
manitos9314053manitos
manitous1039173manitous
manitu8315823manitu__
manless93012933manless
manna75522543man_na_
mannan85413623man_nan
mannans93611523mannans
manners93417833manners
manors84420883man_ors
manos74933623man__os
manque17259513manqu_e
mans66354553man___s
manses84225513man_ses
manteaux1742883manteaux
mantel84317973mant_el
mantic104120903mant_ic
mantid93820383mant_id
mantillas1147043mantillas
mantises10317923mantises
mantissa1044573mantissa
mantissas1143873mantissas
mantle84420923mant_le
mantled104113393mantled
mantlet93620993mantlet
mantlets104611203mantlets
mantric11311353mantric
manuary1237773man_uary
manure8313653man_ure
manures9313353manures
maquis17249483ma_quis
maracas11313773maracas
marantas10310023marant_as
maras75443293ma__ras
marauds1037553marauds
marinas93519393marinas
markas124717003ma_rkas
markkas12356083markkas
markups1534963markups
marques182610863marques
marquis18247063marquis
martens93714953martens
martial92415413martial
martian93514683martian
martians103111613martians
martins93322063martins
marts77442233mart__s
martyrs1234893martyrs
masalas9312053masalas
masas75630413ma__sas
masques18239363masques
massas85116463ma_ssas
mastabas1246803mastabas
masters94628923masters
mastics112614783mastics
masts77035763mast__s
maters85032393ma_ters
mates75251363ma_t_es
mateys115610943ma_teys
maths105624023ma_t_hs
matins84527783ma_tins
matrass939403ma_trass
matres84522233ma_tres
mats65460293ma_t__s
matsah1138233ma_tsah
matsahs1236563ma_tsahs
matters94421753matters
mattes85624533ma_ttes
mattins93316143mattins
mattrass1045863mattrass
matts76829183ma_t_ts
mature8313473ma_ture
matures9314313ma_tures
matza16311813ma_tza_
matzah2035963ma_tzah
matzahs2134483ma_tzahs
matzos1749263ma_tzos
mauds85519273ma__uds
mauls76524953ma__uls
mauts75927193ma__uts
mayas105924383ma__yas
mazumas2034623mazumas
meatus85112923meatu_s
mensas85115863men_sas
menta74424423ment_a_
mental84521603ment_al
mentees93214503mentees
mentors9314993mentors
mentum104511713mentu_m
menus75822843men_u_s
minas75434113min__as
miniums113910223miniums
minters93822473minters
mints76834043mint__s
minus75223933min_u_s
minutes93513443minutes
monas74732153mon__as
montes84226933mont_es
months113812933mont_hs
muktuks1242253muktuks
muntins92715133muntins
muntjac1852053muntjac
muntjacs1941863muntjacs
muntjak2042313muntjak
muntjaks2142003muntjaks
mutual838503m_utual
mutuals937133m_utuals
mynas105815233myn__as
nanas55928633nan__as
omentums1243973omentums
panadas103312213panadas
panamas113112763panamas
pandas95521963pan_das
panduras1136953panduras
panfuls1237173panfuls
pangas99921103pan_gas
panties94230933panties
pantos85222743pant_os
pantoums1236713pantoums
pants76536923pant__s
pastas85422873past_as
pintas85021393pint_as
raitas64417673rait_as
ranters73323643ranters
rants55935343rant__s
ranulas7311773ranulas
sanctums1244013sanctums
sangas75222653san_gas
sannups934463sannups
santeras8311063santeras
santims9312603santims
santirs7312963santirs
santols73513323santols
santos64421833sant_os
santours837183santours
santur6311273santu_r
saxtubas1741913saxtubas
tactual936203tactual
tamanduas1242573tamanduas
tankas104613763tan_kas
tantaras8269543tantaras
tantra63713353tantra_
tantrums1045113tantrums
valutas1036533valutas
vandas103915993van_das
vatus86114643va_tu_s
wanguns1135023wanguns
wanters104420093wanters
wantons103713013wantons
wants87932213want__s
xanthan1736013xanthan
xanthans1845693xanthans
yanquis1943723yanquis
yantra9449623yantra_
yautias1046333yautias
yentas94614213yent_as
zananas16319563zananas
zanzas1487053zan_zas

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 Filter1786911340270.403443402.0
2DLD Change Limit1340273396.08022043.9
3Display Results3393390.1262690.5
 (SQL Overall)1786913396.60927037.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.