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

166 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
mantram11401160(None) 
mantra84116091mantra_
mantrams12288961mantrams
mantrap11379821mantrap
mantras93815861mantras
antra56521922_antra_
antral65719412_antral
antrum8611312_antrum
bantam10314062bant_am
cantrap113310282cantrap
manta75629912mant_a_
mantas85725362mant_as
manteau937862manteau
mantraps12298062mantraps
mantric11311342mantric
mantua84412022mantua_
mantuas93410992mantuas
marram10313882ma_rram
pangram1239022pangram
tangram1038072tangram
tantra63713352tantra_
tantras73112092tantras
tantrum946682tantrum
yantra9449622yantra_
yantras10259002yantras
amtrac10109123_amtrac
anagram1058193_anagram
anorak1038923_anorak
anta46839583_ant_a_
antae56828293_ant_ae
antas55432033_ant_as
anthem113410343_anthem
anthrax1757153_anthrax
antiar6317173_antiar
antijam1648283_antijam
antre55224523_antr_e
antres65021003_antres
antrums969173_antrums
anural65714743_anural
anuran64313243_anuran
ashram1139053_ashram
astral66919283_astral
astray95615543_astray
bantams1149063bant_ams
caltrap11297943caltrap
cantal84122033cant_al
canthal12410053canthal
cantraip12326393cantraip
cantraps12319113cantraps
cantrip112910043cantrip
centra84113883centra_
central93114473central
centrum1168603centrum
contra83314703contra_
contras93015623contras
engram9310653_engram
entrap8710563_entrap
fantasm1236593fantasm
fantom112110803fant_om
gantry103810113gantr_y
gastral8329553gastral
kantar10311153kant_ar
kantars11310033kantars
lactam10310943lact_am
macadam1446853macadam
macrame1338713ma_crame
madam10316223ma__dam
madras94316433ma_dras
madtom1138023madt_om
mailgram1344413mailgram
mainframe1642063mainframe
mainstream1452733mainstream
maltha1137503maltha_
malthas1237913malthas
maltreat1048643maltreat
mana65341963man__a_
manana84816073manana_
mananas93414733mananas
manas76240433man__as
manat76039993man__at
mandrake1546003mandrake
mandrel1038683mandrel
mandril1049353mandril
manga85026203man_ga_
mangas94122923man_gas
mania75634153man_ia_
maniac103917973man_iac
manias84029033man_ias
manila84518303manila_
manilas93915873manilas
manna75522543man_na_
mannan85413623man_nan
mannas85019803man_nas
manor78023933manor__
manorial10311083manorial
manors84420883manor_s
mansard1049313mansard
manteaus1036383manteaus
manteaux1742883manteaux
mantel84317973mant_el
mantels94515043mantels
mantes84430783mant_es
mantic104120903mant_ic
mantid93820383mant_id
mantids103113623mantids
mantis83926033mant_is
mantle84420923mant_le
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
manual8313463man_ual
manuary1237773manuary
manure8313653manur_e
manured1039473manured
manurer938583manurer
manures9313353manures
manurial1047793manurial
manward1349093manward
mara67444573ma__ra_
maras75443293ma__ras
marjoram1944143marjoram
marrams11310123ma_rrams
martial92415413martial
martian93514683martian
matrass939403ma_trass
matres84522233ma_tres
matrix1539843ma_trix
matron83918313ma_tron
matsah1138233ma_tsah
mattrass1045863mattrass
matza16311813ma_tza_
matzah2035963ma_tzah
matzas1749703ma_tzas
mayoral1237693mayoral
menorah1247933menorah
menta74424423ment_a_
mental84521603ment_al
mentum104511713ment_um
mineral9312733mineral
minicam131110053minicam
mistral91013643mistral
mitral81314323m_itral
moneran9311113moneran
monogram1379183monogram
muntjac1852053muntjac
muntjak2042313muntjak
nanogram1145673nanogram
pangrams1337153pangrams
panorama1244943panorama
pantoum1138703pantoum
pantry115014103pantr_y
pastrami1246333pastrami
rattrap945263rattrap
santera7311303santera_
santeras8311063santeras
satrap86212553sa_trap
tangrams1136163tangrams
tantara72410823tantara
tantaras8269543tantaras
tantric939583tantric
tantrism1048373tantrism
tantrums1045113tantrums
tram67034553___tram
untrim8310683_untrim
ventral103612173ventral
xanthan1736013xanthan

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.406440125.6
2DLD Change Limit1340271668.15616432.9
3Display Results1661660.0463608.7
 (SQL Overall)1786911668.60820758.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.