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

113 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
welding12321325(None) 
gelding103911791gelding
melding113414271melding
wedding133411871wedding
weeding123815211weeding
welling112920311welling
welting113615311welting
wending123816841wending
wielding13286861wielding
wilding123814291wilding
balding114015062balding
beading113221862beading
bedding124114482bedding
belling103825072belling
belting104119132belting
belying133612442belying
bending114420892bending
bielding12237472bielding
ceding104014802ce_ding
celling103921262celling
deeding103315122deeding
deleing93313952deleing
deluding1137682deluding
delving123711572delving
dwelling13368412dwelling
eliding93414342_eliding
eluding93412112_eluding
ending83220252_ending
feeding123515072feeding
felling113321132felling
felting113515212felting
fending123717602fending
feuding123410262feuding
fielding13206862fielding
folding123912442folding
geldings11316162geldings
gelling93219762gelling
gilding103813002gilding
heading122919112heading
heeding123515062heeding
helling114623222helling
helming133712002helming
helping133512222helping
helving144011132helving
herding122915122herding
hilding123713532hilding
holding123514282holding
jelling153516612jelling
kelping14319192kelping
leading93419552leading
lending94118532lending
melling102822622melling
melting103317752melting
mending114018682mending
milding113615452milding
molding114213752molding
needing93214422needing
pelting102917272pelting
pending114119772pending
reading93327212reading
redding103218512redding
reding83825562re_ding
reeding94124132reeding
relying112914612relying
rending93924262rending
rewelding1436912rewelding
seeding93719482seeding
selfing112911622selfing
selling83225832selling
sending94221372sending
swelling123212752swelling
tedding103210882tedding
telling83321082telling
tending94419162tending
vending124015262vending
wadding133711942wadding
wading114619532w_ading
waling104525302wal_ing
walking154013302walking
walling113520972walling
warding123918142warding
weaning114117192weaning
wearing113318862wearing
weaving143211622weaving
webbing1536122webbing
weddings14355532weddings
wedging13308722wedging
weening114113972weening
weeping133613672weeping
weeting113816052weeting
weirding1335592weirding
welching17287362welching
welkin1337312welkin_
welkins1437172welkins
welshing15296522welshing
weltings12388202weltings
westing115020272westing
wetting114117382wetting
whelming17304922whelming
whelping17245332whelping
wildings13287932wildings
wildling13248082wildling
wiling103024292wil_ing
willing113821612willing
wilting113515912wilting
winding123517912winding
wolfing14277892wolfing
wooding123012022wooding
wording123014562wording
wyling13368552wyl_ing
yelling113516702yelling
yelping13317872yelping
yielding13205032yielding

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 Limit1076711133.31332499.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911133.73547842.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.