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

120 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
mantraps1229806(None) 
cantraps12319111cantraps
mantrams12288961mantrams
mantrap11379821mantrap_
mantras93815861mantra_s
caltraps12327252caltraps
cantraips13255272cantraips
cantrap113310282cantrap_
cantrips12318932cantrips
entraps9109762_entraps
mantas85725362mant_a_s
manteaus1036382manteaus
mantra84116092mantra__
mantram114011602mantra_m
mantuas93410992mantua_s
matrass939402ma_trass
mattrass1045862mattrass
rattraps1044822rattraps
satraps95011642sa_traps
tantras73112092tantra_s
yantras10259002yantra_s
amtracs1198883_amtracs
anoraks1137603_anoraks
antas55432033_ant_a_s
antiars7314623_antiars
antirape10410113_antirape
antra56521923_antra__
antral65719413_antra_l
antres65021003_antr_es
antrums969173_antrums
anurans73810553_anurans
astrals75515243_astrals
ataps76414833_a_t_aps
bantams1149063bant_ams
caltrap11297943caltrap_
caltrops12307863caltrops
cantals93919573cant_als
cantraip12326393cantraip
cantrip112910043cantrip_
catnaps1197033ca_tnaps
centrals102712033centrals
claptraps1542693claptraps
contras93015623contra_s
entrap8710563_entrap_
enwraps1284833_enwraps
flytraps1642963flytraps
gantries91413793gantries
inwraps12105253_inwraps
kantars11310033kant_ars
madcaps1435243ma_dcaps
madras94316433ma_dra_s
maintops1244403maint_ops
malthas1237913maltha_s
maltreats1145223maltreats
mananas93414733manana_s
manas76240433man__a_s
manats84623463man__ats
mandrake1546003mandrake
mandrakes1646353mandrakes
mandrels1137313mandrels
mandrils1138493mandrils
mangas94122923man_ga_s
maniacs114313063man_iacs
manias84029033man_ia_s
manilas93915873manila_s
mannans93611523man_nans
mannas85019803man_na_s
manors84420883manor__s
manrope1138033man_rope
manropes1237913man_ropes
mansards1148013mansards
manta75629913mant_a__
manteau937863mantea_u
manteaux1742883manteaux
mantels94515043mant_els
mantes84430783mant__es
mantids103113623mant_ids
mantis83926033mant__is
mantises10317923mantises
mantles94820703mant_les
mantlets104611203mantlets
mantric11311353mantr_ic
mantua84412023mantua__
manuals9311213man_uals
manurers1037593manurers
manures9313353manur_es
manwards1447613manwards
maras75443293ma__ra_s
marrams11310123ma_rrams
martians103111613martians
matres84522233ma_tr_es
matrons93517633ma_trons
matsahs1236563ma_tsahs
mattress1036533mattress
matzahs2134483ma_tzahs
matzas1749703ma_tza_s
menorahs1346543menorahs
minerals10311373minerals
mistrals101212623mistrals
monerans10310343monerans
muntjacs1941863muntjacs
muntjaks2142003muntjaks
pangrams1337153pangrams
pantries101817393pantries
rattrap945263rattrap_
santeras8311063santera_s
satrap86212553sa_trap_
satrapy12497933sa_trapy
straps87721783__straps
tangrams1136163tangrams
tantaras8269543tantaras
tantra63713353tantra__
tantrums1045113tantrums
traps75727483___traps
unstraps1045983unstraps
unwraps1255513_unwraps
ventrals112910003ventrals
wataps11248683wa_t_aps
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.423422437.4
2DLD Change Limit1461621206.54622328.4
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.01525472.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.