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

138 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
erasures83721(None) 
erasure736941erasure_
rasures7312011_rasures
embrasures1452712embrasures
ensures73315902e_nsures
erasers74413942eraser_s
erases64425402eras__es
gravures1234902gravures
measures1038912measures
rasure6311422_rasure_
reassures937222reassures
treasures946632treasures
arcatures1186833arcatures
armatures1166973armatures
armures9510273ar_mures
assures7611403_assures
aures55137093__a_ures
azures15510183__azures
brashes124518463bras_hes
brasiers103710513brasiers
brasses93818353bras_ses
brassies103613533brassies
bravuras1343443bravuras
bravure1254393bravure_
censures102211623censures
cerastes101111093ceras_tes
closures10228953closures
crases85532313cras__es
crashers134013233crashers
crashes124618403cras_hes
creatures1138413creatures
dasyures1254153_dasyures
denatures1038123denatures
eagres74014573e_a_gres
eases56041613e_as__es
easies64126633e_as_ies
easters75125683e_asters
ecraseurs1141693ecraseur_s
embrasure1352903embrasure_
endures83314603e_ndures
enraptures1243243enraptures
ensues63313813e_nsu_es
ensure63416003e_nsure_
ensured83512943e_nsured
ensurer73011903e_nsurer
ensurers8279373e_nsurers
enures63919713e__nures
epicures1246513epicures
erase54925493eras__e_
erased74816753eras__ed
eraser64216333eras__er
erasions8310983erasions
eremurus1042733eremurus
eroses65327053eros__es
ersatzes1743073ersatzes
erses55826803er_s__es
etageres936863etageres
evacuees1382483evacuees
exposures1843483exposures
eyases94513683eyas__es
eyasses10388023eyas_ses
eyesores1145113eyesores
features11310333features
fissures1136573fissures
fractures14147233fractures
frasses104314513fras_ses
graduses1046453graduses
granules939933granules
graspers11338403graspers
grasses84117343gras_ses
gravure1134953gravure_
insures73117263_insures
leisures836683leisures
manures9313353_manures
matures9314303_matures
measure939033measure_
measured1136463measured
measurer1035953measurer
measurers1144883measurers
natures7311963_natures
nervatures1363523nervatures
nervures1135123ner_vures
ordures856473or_dures
parures9512693_parures
pastures10311963_pastures
perdures11289683per_dures
perjures17268083per_jures
petasuses1144373petasuses
piastres10249303piastres
pleasures1145573pleasures
prases84429023pras__es
preassures1245273preassures
precures12312903precures
pressures1149063pressures
presumes1239843presumes
priseres10310823priseres
procures1239213procures
raptures1037573_raptures
rares55247443_ra__res
rasers64526783_raser_s
rases55447213_ras__es
rashers104020913_rashers
rashes95330153_ras_hes
raspers94415923_raspers
rassles73513923_rassles
rasters74629023_rasters
reassumes1144463reassumes
reassure847343reassure_
reassured1046103reassured
reinsures937963reinsures
remeasures1243853remeasures
renatures939443renatures
resumes9313373_resumes
resurges9310123_resurges
risuses73210923_risuses
seisures838273seisures
serratures1044863serratures
statures83711113statures
tonsures869133tonsures
traduces1136563traduces
transudes1047593transudes
trashers113013643trashers
trashes104119263tras_hes
trasses74819323tras_ses
treasure846753treasure_
treasured1044983treasured
treasurer944253treasurer
treasurers1043203treasurers
treasuries1045543treasuries
tressures946293tressures
uraeuses835383uraeuses
urares64519093ura__res
urases63723563uras__es
verdures12247753ver_dures
wrasses103812593wras_ses
wrassles11376713wrassles
wrastles11328933wrastles
xeroseres1644683xeroseres

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 Limit1461621386.84321359.3
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.31224438.0
 
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.