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

123 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
snuffly1630520(None) 
sniffly16265641sniffly
snuffily17124321snuffily
snuffle13267831snuffle
snuffy15356241snuff_y
bluffly1833432bluffly
gruffly17413892gruffly
ruffly15336672_ruffly
scuffle15266892scuffle
shuffle16276922shuffle
snaffle13216252snaffle
sniffily17154032sniffily
sniffle13287652sniffle
sniffy15337192sniff_y
snuff113514042snuff__
snuffed14308072snuffed
snuffer13318852snuffer
snuffled15277032snuffled
snuffler14317412snuffler
snuffles14318412snuffles
snuffs12358532snuff_s
snugly1055662snu_gly
souffle13306802souffle
stiffly16235172stiffly
stuffily17124162stuffily
stuffy15317082stuff_y
buffy165013373_buff_y
chuffy20445863chuff_y
duffle13368533_duffle
fluffily1652923fluffily
fluffy14315783fluff_y
gruffily1863083gruffily
gruffy16396013gruff_y
huffily1934693_huffily
huffy174810233_huff_y
knuckly1542473knuckly
knurly13405533knu_rly
muffle14339643_muffle
nubbly13369673_nubbly
nudely10299033_nudely
numbly134410663_numbly
outfly1238273_outfly
pouffy17395883pouff_y
puffily1834843_puffily
puffy164410753_puff_y
ruffle124111673_ruffle
safely12249393s_afely
sandfly1435643sandfly
saucily1237913saucily
sawfly1535133s_awfly
scruffily2041883scruffily
scruffy1842643scruff_y
scuff133914893scuff__
scuffed16298243scuffed
scuffer15328883scuffer
scuffled17256203scuffled
scuffler16286703scuffler
scuffles16287863scuffles
scuffs14419053scuff_s
scurfy14338763scurf_y
shadfly1733783shadfly
shoofly1634353shoofly
shuffled18296243shuffled
shuffler17306803shuffler
shuffles17297783shuffles
sinfully1445613sinfully
skiffle17225203skiffle
sluff114016813sluff__
sluffed14308303sluffed
sluffs12349583sluff_s
smugly1274833smu_gly
snaffled15285213snaffled
snaffles14246043snaffles
snakily1436913snakily
snarly93815003sn_arly
snidely1136813snidely
sniff113915863sniff__
sniffed14318183sniffed
sniffer13318903sniffer
sniffled15276443sniffled
sniffler14296833sniffler
sniffles14257723sniffles
sniffs12378843sniff_s
snowily1336883snowily
snubby1344533snu_bby
snuffbox2341043snuffbox
snuffers14326923snuffers
snuffier14276943snuffier
snuffing15256803snuffing
snufflers15285223snufflers
snufflier1543303snufflier
snuffling1643563snuffling
snuggle9275713snuggle
softly12457763s_oftly
souffled15276193souffled
souffles14298123souffles
soundly1136683soundly
sourly93612213sou_rly
spiffily19153483spiffily
spiffy17326223spiff_y
squally1937673squally
squatly1946433squatly
squiffy2542573squiffy
stubbly1444473stubbly
studly10397693stu_dly
stuff113817053stuff__
stuffed14328973stuffed
stuffer13349793stuffer
stuffs123810223stuff_s
suably112814533s_uably
subtly11249263s_ubtly
suffer124314513s_uffer
suffix1935233s_uffix
sully84622903s_u_lly
sunnily1037833sunnily
supply1346893s_upply
surely93816463s_urely
surfy115319473s_urf_y
surly85124433s_u_rly
swiftly1633733swiftly
truffle1384893truffle
unmuffle1662343unmuffle
waffly18305433_waffly

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271237.51617832.2
3Display Results1231230.0304100.0
 (SQL Overall)1786911237.70223200.6
 
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.