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

151 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
snatching153636(None) 
snitching1535911snitching
batching163712092_batching
catching163712772_catching
hatching173312212_hatching
inarching1546342inarching
latching143712022_latching
matching163512392_matching
notching14288582_notching
patching163212752_patching
scathing14269702scat_hing
scotching1735652scotching
scratching1844532scratching
scutching1735222scutching
searching1538342searching
sketching1935082sketching
smutching1734852smutching
snacking153411702sna_cking
snatchier1455352snatchier
stanching1538082stanching
starching1538592starching
stitching1547102stitching
swathing15248712swat_hing
switching1835702switching
thatching1835142thatching
unlatching1643152unlatching
watching173011172_watching
aching126521973__a_ching
anything1534993anyt_hing
arching136216693__arching
attaching1545433attaching
baching156017753_ba_ching
bathing134816243_bat_hing
beaching164114143bea_ching
bitching163610623_bitching
blanching17297093blanching
blotching1734963blotching
botching16359703_botching
branching17289263branching
caching156317503_ca_ching
clutching17154823clutching
coaching164011963coa_ching
cranching17278733cranching
crutching17216073crutching
despatching20122653despatching
detaching1637263detaching
dispatching20143523dispatching
ditching15349943_ditching
enacting11311363ena_cting
enriching1546153enriching
etching134511843__etching
fetching17298413_fetching
fletching18256143fletching
flitching18265343flitching
gnashing1336423gna_shing
grutching16224373grutching
hatchings18225673_hatchings
hatchling1844953_hatchling
hitching173310523_hitching
hotching17309313_hotching
hutching17318643_hutching
inching134414323in__ching
itching134011683__itching
katchina1745333_katchina
knacking14296713kna_cking
kvetching2242903kvetching
lathing114315693_lat_hing
leaching143012833lea_ching
letching143810263_letching
loathing1247673loat_hing
marching164312193_marching
mismatching21123403mismatching
mispatching21133433mispatching
naething1236073_naething
niching133612433_n_iching
nothing113511903_not_hing
parching164313053_parching
peaching163613643pea_ching
pitching163411113_pitching
poaching163510833poa_ching
ranching141712043_ranching
reaching143317203rea_ching
rematching1844913rematching
repatching1844993repatching
retching143412173_retching
roaching143210433roa_ching
sacking144122703s_a_cking
sacring103115983s_a_cring
sashing114621473s_a_shing
sating74735453s_at__ing
saucing10311003s_auc_ing
scarphing1735243scarphing
scatting113311813scat_ting
scooching1735073scooching
scootching1843363scootching
scorching1735633scorching
scraiching1843793scraiching
scything17264883scyt_hing
seating84130683seat__ing
seething1239023seet_hing
shacking184014083sha_cking
sheathing1636873sheat_hing
skating123613853skat__ing
slacking153914133sla_cking
slashing123713413sla_shing
slating83724653slat__ing
slatting94014233slat_ting
slouching15195723slouching
smacking173510763sma_cking
smashing143310243sma_shing
smirching1744393smirching
smooching1734883smooching
snaffling1643763snaffling
snafuing1235083sna_fuing
snagging11319373sna_gging
snailing92912973sna_iling
snaking123915303sna__king
snapping13349653sna_pping
snarfing12358663sna_rfing
snaring83920953sna__ring
snarling92513183sna_rling
snatch114310603snatch___
snatched14157633snatch_ed
snatcher13167763snatch_er
snatchers14146313snatchers
snatches131410713snatch_es
snatchiest1545153snatchiest
snatchy15355293snatch__y
snawing113612483sna__wing
snicking153610233sn_icking
soothing12269973soot_hing
southing122811823sout_hing
spacing123614493spa_c_ing
spatting113111763spat_ting
splotching1842863splotching
stacking154215083sta_cking
stashing123511583sta_shing
stating83725163stat__ing
staunching1643213staunching
stretching1645813stretching
sunbathing1642933sunbat_hing
swashing15369743swa_shing
swatting12309593swat_ting
synching17227713s_ynching
teaching143612603tea_ching
thatchings1942483thatchings
twitching1834243twitching
unhitching1942843unhitching
untacking1636643untacking
witching173410633_witching
wrathing15248923wrat_hing

Search took 9 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.436409841.7
2DLD Change Limit1486411517.87618872.7
3Display Results1511510.0632396.8
 (SQL Overall)1786911518.37521336.2
 
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.