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

136 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
mantrams1228896(None) 
mantram114011601mantram_
mantraps12298061mantraps
mantras93815861mantra_s
antrums969172_antrums
bantams1149062bant_ams
cantraps12319112cantraps
mantas85725362mant_a_s
manteaus1036382manteaus
mantra84116092mantra__
mantrap11379822mantra_p
mantuas93410992mantua_s
marrams11310122ma_rrams
matrass939402ma_trass
mattrass1045862mattrass
pangrams1337152pangrams
tangrams1136162tangrams
tantras73112092tantra_s
tantrums1045112tantrums
yantras10259002yantra_s
amtracs1198883_amtracs
anagrams1146593_anagrams
anoraks1137603_anoraks
antas55432033_ant_a_s
anthems12309423_anthems
antiars7314623_antiars
antra56521923_antra__
antral65719413_antra_l
antres65021003_antr_es
antrum8611313_antrum_
anurans73810553_anurans
ashrams1236653_ashrams
astrals75515243_astrals
bantam10314063bant_am_
caltraps12327253caltraps
cantals93919573cant_als
cantraip12326393cantraip
cantraips13255273cantraips
cantrap113310283cantra_p
cantrips12318933cantrips
centrals102712033centrals
centrums1236913centrums
contras93015623contra_s
engrams1038073_engrams
entraps9109763_entraps
fantasm1236593fant_asm
fantasms1345633fantasms
fantoms12189153fant_oms
gantries91413783gantries
kantars11310033kant_ars
lactams1136953lact_ams
macadams1545093macadams
macrame1338713ma_crame
macrames1438953ma_crames
madams11310943ma__dams
madras94316433ma_dra_s
madtoms1236923madt_oms
mailgrams1443633mailgrams
mainframe1642063mainframe
mainframes1752333mainframes
mainstreams1552273mainstreams
malthas1237913maltha_s
maltreats1145223maltreats
mananas93414733manana_s
manas76240433man__a_s
manats84623463man__ats
mandamus1345523man_damus
mandrake1546003mandrake
mandrakes1646353mandrakes
mandrels1137313mandrels
mandrils1138493mandrils
mangas94122923man_ga_s
maniacs114313063man_iacs
manias84029033man_ia_s
manilas93915873manila_s
mannans93611523man_nans
mannas85019803man_na_s
manors84420883manor__s
mansards1148013mansards
manta75629913mant_a__
manteau937863mantea_u
manteaux1742883manteaux
mantels94515043mant_els
mantes84430783mant__es
mantids103113623mant_ids
mantis83926033mant__is
mantises10317923mantises
mantles94820703mant_les
mantlets104611203mantlets
mantric11311343mantr_ic
mantua84412023mantua__
manuals9311213man_uals
manurers1037593manurers
manures9313353manur_es
manwards1447613manwards
maras75443293ma__ra_s
marjorams2043003marjorams
marram10313883ma_rram_
martians103111613martians
matres84522233ma_tr_es
matrons93517633ma_trons
matsahs1236563ma_tsahs
mattress1036533mattress
matzahs2134483ma_tzahs
matzas1749703ma_tza_s
menorahs1346543menorahs
minerals10311373minerals
minicams14126863minicams
mistrals101212623mistrals
monerans10310343monerans
monograms1478263monograms
muntjacs1941863muntjacs
muntjaks2142003muntjaks
nanograms1244843nanograms
pangram1239023pangram_
panorama1244943panorama
panoramas1344273panoramas
pantoums1236713pantoums
pantries101817393pantries
pastrami1246333pastrami
pastramis1345683pastramis
rattraps1044823rattraps
santeras8311063santera_s
santims9312603sant_ims
satraps95011643sa_traps
tangram1038073tangram_
tantaras8269543tantaras
tantra63713353tantra__
tantrism1048373tantrism
tantrisms1146323tantrisms
tantrum946683tantrum_
trams75327673___trams
untrims938613_untrims
ventrals112910003ventrals
xanthans1845693xanthans
yantra9449623yantra__

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621367.06320694.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.52923733.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.