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

135 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
snuffle1326783(None) 
scuffle15266891scuffle
shuffle16276921shuffle
snaffle13216251snaffle
sniffle13287651sniffle
snuffled15277031snuffled
snuffler14317411snuffler
snuffles14318411snuffles
snuffly16305201snuffly
souffle13306801souffle
duffle13368532_duffle
muffle14339642_muffle
ruffle124111672_ruffle
scuffled17256202scuffled
scuffler16286702scuffler
scuffles16287862scuffles
shuffled18296242shuffled
shuffler17306802shuffler
shuffles17297782shuffles
skiffle17225202skiffle
snaffled15285212snaffled
snaffles14246042snaffles
sniffled15276442sniffled
sniffler14296832sniffler
sniffles14257722sniffles
sniffly16265642sniffly
snuff113514042snuff__
snuffed14308072snuffed
snuffer13318852snuffer
snuffier14276942snuffier
snuffily17124322snuffily
snufflers15285222snufflers
snufflier1543302snufflier
snuffs12358532snuff_s
snuffy15356242snuff_y
snuggle9275712snuggle
souffled15276192souffled
souffles14298122souffles
truffle1384892truffle
unmuffle1662342unmuffle
baffle14399873_baffle
bluffly1833433bluffly
bouffe14438313bouff_e
coffle14359043_coffle
duffel13407753_duffel
duffles14308923_duffles
gruffly17413893gruffly
inutile739883inutile
knuckle1254233knuckle
muffled16377783_muffled
muffler15398343_muffler
muffles153910453_muffles
nubble103813713_nubble
nubile83212713_nubile
nuncle839363_nuncle
nuzzle14298083_nuzzle
piffle14418233_piffle
pouffe14448263pouff_e
purfle112511183_purfle
raffle123910703_raffle
reshuffle1851933reshuffle
riffle124210233_riffle
ruffe114713813_ruff_e
ruffled14369153_ruffled
ruffler13369723_ruffler
ruffles133512273_ruffles
ruffly15336673_ruffly
scuff133914893scuff__
scuffed16298243scuffed
scuffer15328883scuffer
scufflers17285033scufflers
scuffs14419053scuff_s
scumble1337013scumble
scuttle936463scuttle
shufflers18265153shufflers
shuttle1046103shuttle
skiffled19244423skiffled
skiffles18265713skiffles
sluff114016813sluff__
sluffed14308303sluffed
sluffs12349583sluff_s
smuggle11265013smuggle
sniff113915863sniff__
sniffable1743773sniffable
sniffed14318183sniffed
sniffer13318903sniffer
sniffier14356643sniffier
sniffily17154033sniffily
snifflers15275053snifflers
sniffs12378843sniff_s
sniffy15337193sniff_y
sniggle9316833sniggle
snoozle16305913snoozle
snuffbox2341043snuffbox
snuffers14326923snuffers
snuffiest15246053snuffiest
snuffing15256803snuffing
snuffliest1643503snuffliest
snuffling1643563snuffling
snuggled11234953snuggled
snuggles10306143snuggles
snugly1055663snu_gly
souffleed16272903souffleed
spurtle937453spurtle
stiffie13245773stiffie
stiffly16235173stiffly
stifle93611903s_tifle
stubble1136843stubble
stuff113817053stuff__
stuffed14328973stuffed
stuffer13349793stuffer
stuffier14336623stuffier
stuffily17124163stuffily
stuffless1543543stuffless
stuffs123810223stuff_s
stuffy15317083stuff_y
stumble1147553stumble
suable83920553s_uable
subfile122010503subfile
subtle82113433s_ubtle
suckle124015963s_uckle
suffer124314513s_uffer
suffice15197573s_uffice
suffix1935233s_uffix
sufflate1456183s_ufflate
suffuse1335443s_uffuse
supple10410203s_upple
truffe1276233truff_e
truffled1563993truffled
truffles1485593truffles
unmuffled1872343unmuffled
unmuffles1772063unmuffles
unruffled1672923unruffled
waffle15369183_waffle
whiffle1933533whiffle

Search took 7 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 Limit1340271356.42320866.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.62526972.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.