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

128 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
erasure73694(None) 
erasures837211erasures
rasure6311421_rasure
bravure1254392bravure
embrasure1352902embrasure
ensure63416002e_nsure
erase54925492eras__e
eraser64216332eraser_
erasers74413942erasers
gravure1134952gravure
measure939032measure
rasures7312012_rasures
reassure847342reassure
treasure846752treasure
arcature1086483arcature
armature10106963armature
armure8710133ar_mure
assure6610773_assure
azure14911483__azure
brasher124515243brasher
brasier94516753brasier
brassie93411523brassie
bravura1253603bravura
censure92310603censure
closure9278483closure
crasher124616163crasher
crasser94114333crasser
creature1038723creature
dasyure1153823_dasyure
denature938063denature
eagre64315323e_a_gre
ease45042333e_as__e
easier64218463e_asier
easter65027983e_aster
ecraseur1041803ecraseur_
ecraseurs1141693ecraseurs
embrasures1452713embrasures
endure74014143e_ndure
enrapture1143263enrapture
ensue54013833e_nsu_e
ensured83512943e_nsured
ensurer73011903e_nsurer
ensures73315903e_nsures
enure53520223e__nure
epicure1136823epicure
eras45441503eras___
erasable10511043erasable
erased74816753eras_ed
erases64425403eras_es
erasing8317963erasing
erasion7311963erasion
eremuri944043eremuri
erose55727273eros__e
erosive1039193erosive
etagere836533etagere
evacuee12105073evacuee
evasive1344663evasive
exposure1743673exposure
eyesore1046173eyesore
feature1039853feature
fissure1036783fissure
fracture13147123fracture
granule839473granule
grasper10389793grasper
gravures1234903gravures
insure63416603_insure
leisure736693leisure
manure8313653_manure
mature8313463_mature
measured1136463measured
measurer1035953measurer
measures1038913measures
nature6311263_nature
nervature1263823nervature
nervure1034973ner_vure
ordure756813or_dure
oversure111611163over_sure
parure8312523_parure
pasture9311463_pasture
perdure10379623per_dure
perjure16327963per_jure
piastre9307893piastre
pleasure1045543pleasure
prase76128753pras__e
preassure1145623preassure
precure11312553precure
pressure1039773pressure
presume11310303presume
prisere9310943prisere
procure1138573procure
rapture937383_rapture
rare45348433_ra__re
rase46149983_ras__e
raser55633413_raser_
rasers64526783_rasers
rasher95024123_rasher
rasper83917333_rasper
rassle63813203_rassle
raster64731443_raster
reassume1044633reassume
reassured1046103reassured
reassures937223reassures
reinsure837913reinsure
remeasure1143943remeasure
renature839323renature
resume8313783_resume
resurge839073_resurge
seisure738193seisure
serrature945003serrature
stature74410683stature
sure45447413___sure
tonsure758783tonsure
traduce1036353traduce
transude947083transude
trasher104416133trasher
treasured1044983treasured
treasurer944253treasurer
treasures946633treasures
treasury1143793treasury
tressure846483tressure
unsure62815413_unsure
urare56322553ura__re
urase54624683uras__e
verdure11287773ver_dure
wrasse9398773wras_se
wrassle10357173wrassle
wrastle10368993wrastle
xerosere1544733xerosere

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 Filter1786911340270.203880251.2
2DLD Change Limit1340271287.45317983.0
3Display Results1281280.0502560.0
 (SQL Overall)1786911287.70623188.6
 
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.