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

139 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
snaffle1321625(None) 
snaffled15285211snaffled
snaffles14246041snaffles
sniffle13287651sniffle
snuffle13267831snuffle
baffle14399872_baffle
raffle123910702_raffle
scuffle15266892scuffle
shuffle16276922shuffle
skiffle17225202skiffle
sniffled15276442sniffled
sniffler14296832sniffler
sniffles14257722sniffles
sniffly16265642sniffly
snuffled15277032snuffled
snuffler14317412snuffler
snuffles14318412snuffles
snuffly16305202snuffly
souffle13306802souffle
waffle15369182_waffle
baffled16418063_baffled
baffler15418113_baffler
baffles153710683_baffles
coffle14359043_coffle
duffle13368533_duffle
enable83318483ena_ble
gaffe124111653_gaff_e
muffle14339643_muffle
naff105128933_naff__
naffed13408333_naffed
naffs116213963_naff_s
piaffe1494913piaff_e
piffle14418233_piffle
raffled14429083_raffled
raffler13339223_raffler
raffles133611853_raffles
riffle124210233_riffle
ruffle124111673_ruffle
sable74732163s_a_ble
saddle83915493s_addle
safe75930953s_a_f_e
safely12249393s_afely
safrole1037253s_afrole
sale44959703s_a__le
sample104215013s_ample
sandfly1435643sandfly
sanicle91210263sanicle
sawfly1535133s_awfly
scabble13168653scabble
scaffold1742233scaffold
scale74629143sca__le
scuffled17256203scuffled
scuffler16286703scuffler
scuffles16287863scuffles
shackle16409543shackle
shadfly1733783shadfly
shale85332833sha__le
shamble14149263shamble
shuffled18296243shuffled
shuffler17306803shuffler
shuffles17297783shuffles
skatole1135693skatole
skiffled19244423skiffled
skiffles18265713skiffles
snaffling1643763snaffling
snafu8412143sna_f_u
snafued1134933snafued
snafus936743sna_fus
snail57020203sna_il_
snailed83811923sna_iled
snails64816653sna_ils
snake94821113sna__ke
snakily1436913snakily
snare54429983sna__re
snarf86525423snarf__
snarfed11378753snarfed
snarfs95113423snarf_s
snarl54921083sna_rl_
snarled83612363sna_rled
snarler73610633sna_rler
snarls64016873sna_rls
snarly93815003sna_rly
snathe94415113sna_the
sniff113915863sniff__
sniffable1743773sniffable
sniffed14318183sniffed
sniffer13318903sniffer
sniffier14356643sniffier
sniffily17154033sniffily
snifflers15275053snifflers
sniffs12378843sniff_s
sniffy15337193sniff_y
sniggle9316833sniggle
snoozle16305913snoozle
snuff113514043snuff__
snuffed14308073snuffed
snuffer13318853snuffer
snuffier14276943snuffier
snuffily17124323snuffily
snufflers15285223snufflers
snufflier1543303snufflier
snuffs12358533snuff_s
snuffy15356243snuff_y
snuggle9275713snuggle
souffled15276193souffled
souffles14298123souffles
spackle15369573spackle
spale74929213spa__le
spangle1038403spangle
sparkle133710213sparkle
spatzle1834583spatzle
stabile9312063stabile
stable83921643sta_ble
staddle9288093staddle
staff113817713staff__
staffed14298283staffed
staffer13299093staffer
staffs12349753staff_s
stale55637103sta__le
staple84415823sta_ple
startle72511123startle
stiffie13245773stiffie
stiffly16235173stiffly
stifle93611903s_tifle
suable83920553sua_ble
subfile122010503subfile
swaddle12276743swaddle
swale85221593swa__le
truffle1384893truffle
unable83819223una_ble
unagile838283unagile
unmuffle1662343unmuffle
waffie15338563_waffie
waffled17357523_waffled
waffler16377783_waffler
waffles16329983_waffles
waffly18305433_waffly
whiffle1933533whiffle
zaffre21354663_zaffre

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.403443402.0
2DLD Change Limit1340271396.78319759.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.24924650.4
 
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.