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

138 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
snaffles1424604(None) 
snaffle13216251snaffle_
snaffled15285211snaffled
sniffles14257721sniffles
snuffles14318411snuffles
baffles153710682_baffles
raffles133611842_raffles
scuffles16287862scuffles
shuffles17297782shuffles
skiffles18265712skiffles
sniffle13287652sniffle_
sniffled15276442sniffled
sniffler14296832sniffler
snifflers15275052snifflers
snuffle13267832snuffle_
snuffled15277032snuffled
snuffler14317412snuffler
snufflers15285222snufflers
souffles14298122souffles
waffles16329982_waffles
baffies153612943_baffies
baffle14399873_baffle_
baffled16418063_baffled
baffler15418113_baffler
bafflers16356593_bafflers
coffles152610003_coffles
duffles14308923_duffles
enables92813123ena_bles
gaffes134811103_gaff_es
muffles153910453_muffles
naffed13408333_naff_ed
naffs116213963_naff__s
piaffes15115053piaff_es
piffles15368763_piffles
raffle123910703_raffle_
raffled14429083_raffled
raffler13339223_raffler
rafflers14317363_rafflers
riffles133911163_riffles
ruffles133512273_ruffles
sables85026693s_a_bles
saddles95415743s_addles
safes85226723s_a_f_es
safroles1136933s_afroles
sales56055593s_a__les
samples112815453s_amples
sandflies1346513sandflies
sanicles10149943sanicles
sawflies1444743s_awflies
scabbles14167983scabbles
scaffolds1841573scaffolds
scales84529313sca__les
scuffle15266893scuffle_
scuffled17256203scuffled
scuffler16286703scuffler
scufflers17285033scufflers
shackles173010593shackles
shadflies1643833shadflies
shales94731253sha__les
shambles15159043shambles
shuffle16276923shuffle_
shuffled18296243shuffled
shuffler17306803shuffler
shufflers18265153shufflers
skatoles1236143skatoles
skiffle17225203skiffle_
skiffled19244423skiffled
skiffless19243053skiffless
snaffling1643763snaffling
snafued1134933sna_fued
snafus936743sna_f_us
snailed83811923sna_iled
snails64816653sna_il_s
snakes103919603sna__kes
snapless10287463sna_pless
snares65329033sna__res
snarfed11378753snarf_ed
snarfs95113423snarf__s
snarled83612363sna_rled
snarler73610633sna_rler
snarlers8298753sna_rlers
snarls64016873sna_rl_s
snashes105214753sna_shes
snatches131410713snatches
snathes104816493sna_thes
sniffed14318183sniff_ed
sniffer13318903sniff_er
sniffers14257123sniffers
sniffier14356643sniffier
sniffiest15236003sniffiest
sniffly16265643sniffl_y
sniffs12378843sniff__s
sniggles10307313sniggles
snoozles17335563snoozles
snuffed14308073snuff_ed
snuffer13318853snuff_er
snuffers14326923snuffers
snuffier14276943snuffier
snuffiest15246053snuffiest
snufflier1543303snufflier
snuffliest1643503snuffliest
snuffly16305203snuffl_y
snuffs12358533snuff__s
snuggles10306143snuggles
souffle13306803souffle_
souffled15276193souffled
spackles16319953spackles
spales84728103spa__les
spangles1138893spangles
sparkles143210493sparkles
spatzles1935303spatzles
spiffies16277993spiffies
stabiles10311403stabiles
stables93219073sta_bles
staddles10258693staddles
staffed14298283staff_ed
staffer13299093staff_er
staffers14247083staffers
staffs12349753staff__s
stales65538293sta__les
staples93617213sta_ples
startles82111963startles
stiffies14258383stiffies
stifles103013393s_tifles
stuffless1543543stuffless
subfiles131710723subfiles
swaddles13296453swaddles
swales93920763swa__les
taffies133012693_taffies
truffles1485593truffles
unmuffles1772063unmuffles
waffies163611443_waffies
waffle15369183_waffle_
waffled17357523_waffled
waffler16377783_waffler
wafflers17306323_wafflers
whiffles2034263whiffles
zaffres22324993_zaffres

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621387.97018339.0
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.18921820.9
 
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.