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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
herding12291512(None) 
heading122919111heading
heeding123515061heeding
herring113615881herring
hording123517051hording
barding113822892barding
beading113221862beading
bearding124011942bearding
bedding124114482bedding
bending114420892bending
berming123614832berming
birding114014922birding
carding113922442carding
ceding104014802ce_ding
cering94522532cer_ing
chording15410152chording
cording113620822cording
curding113515132curding
deeding103315122deeding
deriding112512932deriding
ending83220252_ending
eroding9314272_eroding
erring73816482_erring
farding123716742farding
feeding123515072feeding
fending123717602fending
feuding123410262feuding
fording123717042fording
gelding103911792gelding
girding103611882girding
hading113922942h_ading
handing123518892handing
haring104233002har_ing
harking154120942harking
harming133717932harming
harping134118382harping
headings133510492headings
healing113922962healing
heaping133015852heaping
hearing113324162hearing
hearsing1239382hearsing
hearting12513122hearting
heating114024322heating
heaving144114762heaving
hedging13348952hedging
heeling113618512heeling
heezing20349872heezing
hefting144510912hefting
heiling113616362heiling
heiring113312902heiring
helling114623222helling
helming133712002helming
helping133512222helping
helving144011132helving
hemming15269972hemming
henting113719652henting
heralding1435772heralding
herdic123112302herdi_c
herdics13249522herdics
herein93717792herein_
heroin94420592heroin_
heroine103517492heroine
heroins103518012heroins
herrings12379532herrings
herrying15147032herrying
hewing134514242he_wing
hexing174210512he_xing
hiding114319332h_iding
hilding123713532hilding
hiring104421602hir_ing
hoarding13288642hoarding
holding123514282holding
hooding123815202hooding
horning113015002horning
horsing113215582horsing
hurdling13288012hurdling
hurling113616412hurling
hurting113914032hurting
jerking19308922jerking
kerbing14308482kerbing
kerfing15307532kerfing
kerning124010892kerning
larding92917872larding
leading93419552leading
lending94118532lending
lording93115232lording
melding113414272melding
mending114018682mending
merging112711762merging
needing93214422needing
nerving112910832nerving
pending114119772pending
perking143716462perking
perming123416092perming
reading93327212reading
redding103218512redding
reding83825562re_ding
reeding94124132reeding
rending93924262rending
seeding93719482seeding
sending94221372sending
serging93416672serging
sering74731812ser_ing
serving113014982serving
shedding14278112shedding
shending132511252shending
tedding103210882tedding
tending94419162tending
terming104016002terming
vending124015262vending
verdin103113022verdin_
verdins112812332verdins
verging123812302verging
versing112314192versing
warding123918142warding
wedding133411872wedding
weeding123815212weeding
weirding1335592weirding
welding123213252welding
wending123816842wending
wording123014562wording
yarding123413142yarding
yerking15368812yerking
zeroing1738342zeroing

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.373479064.3
2DLD Change Limit1076711243.36032044.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911243.77947285.3
 
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.