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

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

100 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
erasing831796(None) 
easing74926461e_asing
rasing74330831_rasing
abasing10610672abasing
aerating92821002aerating
arising83619972arising
basing95427662_basing
beraking153612972beraking
berating113220762berating
biasing103512452biasing
bracing123817612bracing
braising113014562braising
braking143917712braking
brassing112612302brassing
braving133714612braving
braying134416312braying
brazing193715112brazing
casing94829102_casing
ceasing104118262ceasing
chasing133715892chasing
craning103620302craning
craping124018712craping
crashing143512632crashing
crating103725202crating
craving134015732craving
crazing193914582crazing
creasing113314442creasing
debasing12238062debasing
derating103222282derating
draping114213352draping
drawing123812052drawing
draying123813842draying
earing75235482e_aring
earning83418212earning
earring83519012earring
easting84924302e_asting
eating75134402e_ating
elapsing1146712elapsing
elating83423082elating
encasing11610822encasing
enraging1049572enraging
erasion7311962erasion
erasions8310982erasions
erlking1236702erlking
eroding9314272eroding
erring73816482er_ring
evading1237282evading
feasing113916652feasing
framing133014792framing
fraying143413432fraying
gracing113216442gracing
grading103918712grading
grasping12348832grasping
grassing103311972grassing
grating93923182grating
graving123114562graving
graying124115882graying
grazing183514552grazing
greasing102811392greasing
hearsing1239382hearsing
irising83614422irising
lasing74727982_lasing
leasing83920162leasing
orating83520322orating
parsing103819552parsing
perusing11811062perusing
phasing133211672phasing
phrasing1438012phrasing
praising113214562praising
prating103424452prating
praying133717322praying
prising103321452prising
prosing103319382prosing
racing95030532_racing
raging85126432_raging
raising83220532_raising
raking114728422_raking
raping94829852_raping
raring74332872_raring
rasping104316252_rasping
rating74938702_rating
raving105128852_raving
raxing144321022_raxing
raying105027192_raying
razing164524542_razing
reading93327212reading
reaming103924012reaming
reaping103621212reaping
rearing83128782rearing
reaving113820532reaving
reraising10313772reraising
rerising93017782rerising
reusing82516782reusing
rising74025882_rising
rosing73925592_rosing
teasing83918512teasing
tracing103720152tracing
trading93517972trading
trashing122613222trashing
versing112314192ver_sing

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711003.40331640.0
3Display Results1001000.0333030.3
 (SQL Overall)1786911003.81246875.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.