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 “sketching” 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
sketching193508(None) 
etching134511842__etching
fetching17298412_fetching
fletching18256142fletching
kvetching2242902kvetching
letching143810262_letching
resketching2142272resketching
retching143412172_retching
scotching1735652scotching
scutching1735222scutching
seething1239022seet_hing
sketchier1853412sketchier
sketchily2142332sketchily
smutching1734852smutching
snatching1536362snatching
snitching1535912snitching
stitching1547102stitching
stretching1645812stretching
switching1835702switching
batching163712093_batching
beaching164114143_beaching
belching16349153_belching
benching163411343_benching
bitching163610623_bitching
bleaching17287093bleaching
blenching17276503blenching
blotching1734963blotching
botching16359703_botching
breaching17269403breaching
breeching17236473breeching
catching163712773_catching
clenching17266303clenching
clutching17154823clutching
crutching17216073crutching
detaching1637263_detaching
ditching15349943_ditching
drenching16256033drenching
eching126315563__e_ching
etchings14396293__etchings
fleeching18305013fleeching
flenching18296703flenching
fletchings19282863fletchings
flitching18265343flitching
frenching18267753frenching
grutching16224373grutching
hatching173312213_hatching
hitching173310523_hitching
hotching17309313_hotching
hutching17318643_hutching
itching134011683__itching
katchina1745333_katchina
kecking134111883_ke_cking
kithing153411553_kit_hing
kything18285523_kyt_hing
latching143712023_latching
leaching143012833_leaching
leching134613653_le_ching
leeching14318373_leeching
matching163512393_matching
naething1236073naet_hing
notching14288583_notching
patching163212753_patching
peaching163613643_peaching
peching154513903_pe_ching
perching163711633_perching
pitching163411113_pitching
pleaching17257083pleaching
preaching172811163preaching
quenching2443923quenching
reaching143317203_reaching
scathing14269703scat_hing
scooching1735073scooching
scootching1843363scootching
scorching1735633scorching
scratching1844533scratching
screeching1843643screeching
scything17264883scyt_hing
searching1538343searching
setting83621393s_et_ting
settling978943s_ettling
sheathing1636873sheathing
skating123613853skat__ing
skeeing12308853ske__eing
skeining1347073ske_ining
skelping1535973ske_lping
skeltering1545003skeltering
sketch1535363sketch___
sketched1835393sketch_ed
sketcher1735433sketch_er
sketchers1834513sketchers
sketches1746823sketch_es
sketchiest1943163sketchiest
sketchiness2052173sketchiness
sketchpad2161363sketchpad
sketchy1943053sketch__y
skewering1744633skewering
skewing15318723ske__wing
skiting123812503skit__ing
skreeghing1941483skreeghing
skreighing1942303skreighing
sleighing1434213sleighing
sleuthing1334203sleuthing
slouching15195723slouching
smirching1744393smirching
smooching1734883smooching
something1545403somet_hing
soothing12269973soot_hing
southing122811823sout_hing
speccing15306643spe_ccing
specking17359733spe_cking
splotching1842863splotching
squelching2542233squelching
stanching1538083stanching
starching1538593starching
stetting93410713stet_ting
swathing15248713swat_hing
synching17227713s_ynching
teaching143612603_teaching
teething1237163teet_hing
thatching1835143thatching
trenching15227653trenching
twitching1834243twitching
vetchling1843593_vetchling
watching173011173_watching
welching17287363_welching
wenching17328863_wenching
witching173410633_witching
wrenching18276273wrenching

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411287.15620771.5
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.60823487.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.