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 “mattrass” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
mattrass104586(None) 
matrass939401ma_trass
mattress1036531mattress
mantrams12288962mantrams
mantraps12298062mantraps
mantras93815862mantra_s
mattrasses1243832mattrasses
rattraps1044822rattraps
actress948533_actress
amtracs1198883_amtracs
astrals75515243_astrals
attars64515313_att_ars
attract9511833_attract
attracts1047793_attracts
attrits7310613_attrits
buttress1035883buttress
caltraps12327253caltraps
cantraps12319113cantraps
caterans10313223caterans
cateress102311613cateress
cutgrass1144343cutgrass
daturas838773datura_s
harass9313943ha__rass
laterals8312753laterals
madras94316433ma_dra_s
madrasa10387883ma_drasa
madrasas11317763ma_drasas
madrases112610003ma_drases
madrassa11274633ma_drassa
maltase938903malt_ase
maltases1039693malt_ases
malthas1237913maltha_s
maltreats1145223maltreats
mantas85725363mant_a_s
manteaus1036383manteaus
mantra84116093mantra__
mantram114011603mantra_m
mantrap11379823mantra_p
mantuas93410993mantua_s
maras75443293ma__ra_s
marrams11310123ma_rrams
martians103111613martians
mastless102610023mastless
matelasse1163083matelasse
mateless102711293mateless
materials11510793materials
maters85032393mater__s
matiness102114753matiness
matless93014043ma_tless
matrasses1157293ma_trasses
matres84522233ma_tr_es
matrons93517633ma_trons
matsahs1236563ma_tsahs
matters94421753matt_ers
mattes85624533matt__es
mattings11369673mattings
mattins93316143matt_ins
mattocks1644983mattocks
mattoids1196183mattoids
mattresses1245433mattresses
matts76829183matt___s
maturate10312613maturate
maturates11311763maturates
maturers1037373maturers
matures9314303matur_es
maturest1039693maturest
matzahs2134483ma_tzahs
matzas1749703ma_tza_s
mayoress1344383mayoress
mistrals101212623mistrals
mistress10310703mistress
morass84614503m__orass
naturals847903naturals
nutgrass943933nutgrass
rattans73411953ratt_ans
rattrap945263rattra_p
raygrass1242883raygrass
sataras7315063satara_s
satraps95011643sa_traps
smartass1044273smart_ass
strass67117223__strass
tantras73112093tantra_s
trass56226473___trass
waitress1135223waitress
wattless11268723wattless
yantras10259003yantra_s

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 Filter1786911461620.423422437.4
2DLD Change Limit146162867.73318901.1
3Display Results86860.0332606.1
 (SQL Overall)178691868.18921820.9
 
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.