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

131 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
snaffled1528521(None) 
snaffle13216251snaffle_
snaffles14246041snaffles
sniffled15276441sniffled
snuffled15277031snuffled
baffled16418062_baffled
naffed13408332_naff_ed
raffled14429082_raffled
scuffled17256202scuffled
shuffled18296242shuffled
skiffled19244422skiffled
snafued1134932sna_fued
snailed83811922sna_iled
snarfed11378752snarf_ed
snarled83612362sna_rled
sniffed14318182sniff_ed
sniffle13287652sniffle_
sniffler14296832sniffler
sniffles14257722sniffles
snuffed14308072snuff_ed
snuffle13267832snuffle_
snuffler14317412snuffler
snuffles14318412snuffles
souffled15276192souffled
staffed14298282staff_ed
waffled17357522_waffled
baffed154812173_baff_ed
baffle14399873_baffle_
baffler15418113_baffler
baffles153710683_baffles
chaffed19387703chaff_ed
coffled16297363_coffled
daffed14429493_daff_ed
enabled102510633ena_bled
enameled1136373enameled
gaffed144210203_gaff_ed
gnarled9287723gna_rled
muffled16377783_muffled
nailed74021493_na_iled
naled65525053_na__led
piaffed1693753piaff_ed
piffled16366403_piffled
quaffed2334253quaff_ed
raffle123910703_raffle_
raffler13339223_raffler
raffles133611843_raffles
riffled14338603_riffled
ruffled14369153_ruffled
saddled103112033s_addled
sailed74327763s_a_iled
sampled123410793s_ampled
sandaled1039243sandaled
scabbled15156303scabbled
scaffold1742233scaffold
scaffolded2051023scaffolded
scaled94822443sca__led
scarfed134711183scarf_ed
sclaffed17102673sclaff_ed
scoffed16266183scoff_ed
scuffed16298243scuff_ed
scuffle15266893scuffle_
scuffler16286703scuffler
scuffles16287863scuffles
sealed74328363sea__led
shackled18277603shackled
shafted14288813sha_fted
shaled105023953sha__led
shambled16156153shambled
shauled1148793sha_uled
shawled1437773sha_wled
shuffle16276923shuffle_
shuffler17306803shuffler
shuffles17297783shuffles
skiffle17225203skiffle_
skiffles18265713skiffles
sluffed14308303sluff_ed
snacked144013113sna_cked
snaffling1643763snaffling
snagged104010673sna_gged
snaked115017593sna__ked
snapped124611203sna_pped
snapweed1443453snapweed
snared74824553sna__red
snarler73610633sna_rler
snatched14157633snatched
snawed104813733sna__wed
snelled83313043sn_elled
sniffer13318903sniff_er
sniffier14356643sniffier
snifflers15275053snifflers
sniffly16265643sniffl_y
sniggled11275743sniggled
sniveled1255463sniveled
snooled84513933sn_ooled
snoozled18344493snoozled
snuffer13318853snuff_er
snuffier14276943snuffier
snufflers15285223snufflers
snufflier1543303snufflier
snuffly16305203snuffl_y
snuggled11234953snuggled
souffle13306803souffle_
souffleed16272903souffleed
souffles14298123souffles
spackled17297803spackled
spalled103113133spa_lled
spangled1236153spangled
sparkled15317733sparkled
spiffed16257103spiff_ed
spiffied17234823spiffied
stabled103514953sta_bled
staffer13299093staff_er
staled74728103sta__led
stalled83515683sta_lled
stapled103613703sta_pled
startled9208563startled
stiffed14359583stiff_ed
stifled113511093s_tifled
stuffed14328973stuff_ed
swaddled14254963swaddled
truffled1563993truffled
unaneled939793unaneled
unmuffled1872343unmuffled
unrifled1237423unrifled
unruffled1672923unruffled
waffed16459793_waff_ed
waffle15369183_waffle_
waffler16377783_waffler
waffles16329983_waffles
whiffled2133043whiffled
yaffed16457323_yaff_ed

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621317.28320068.9
3Display Results1311310.0433046.5
 (SQL Overall)1786911317.48223882.8
 
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.