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

169 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
snuffier1427694(None) 
sniffier14356641sniffier
snuffer13318851snuff_er
snuffler14317411snuffler
snufflier1543301snufflier
stuffier14336621stuffier
buffier1568402_buffier
chuffier1934542chuffier
fluffier13264332fluffier
gruffier1544702gruffier
huffier1637492_huffier
puffier1547972_puffier
scruffier1743302scruffier
scuffer15328882scuff_er
scuffler16286702scuffler
scurfier13267052scurfier
shuffler17306802shuffler
sniffer13318902sniff_er
sniffler14296832sniffler
snubbier1244992snubbier
snuffed14308072snuff_ed
snuffers14326922snuff_ers
snuffiest15246052snuffiest
snuffily17124322snuffily
snuffing15256802snuffing
snuffle13267832snuffle_
snuffled15277032snuffled
snufflers15285222snufflers
snuffles14318412snuffles
spiffier16255882spiffier
squiffier2442842squiffier
stuffer13349792stuff_er
suffer124314512s_uff_er
sufficer16225822s_ufficer
surfier102613542s_urfier
bluffer15396883bluff_er
buffer144512683_buff_er
chaffier1935473chaffier
chuffer18337143chuff_er
cliffier1633913cliffier
daffier1457833_daffier
draffier1574323draffier
duffer134711663_duff_er
fluffer12336503fluff_er
gauffer1474423gauff_er
gruffer1475793gruff_er
gulfier1137793_gulfier
iffier1236763__iffier
knubbier1642513knubbier
knurlier1242883knurlier
miffier1537023_miffier
muffler15398343_muffler
niffer12378443_niff_er
niftier10328713_niftier
nubbier11308133_nubbier
nutsier7329253_nutsier
nuttier73112023_nuttier
puffer144610733_puff_er
ruffler13369723_ruffler
rufflier1434013_rufflier
saucier9810283sau_cier
scoffer15317023scoff_er
scuffed16298243scuff_ed
scuffers16307493scuff_ers
scuffing17287113scuffing
scuffle15266893scuffle_
scuffled17256203scuffled
scufflers17285033scufflers
scuffles16287863scuffles
scummier1445083scummier
scurvier13255883scurvier
scuzzier1842713scuzzier
shiftier1436343shiftier
shuffle16276923shuffle_
shuffled18296243shuffled
shufflers18265153shufflers
shuffles17297783shuffles
skunkier11174283skunkier
sludgier1034823sludgier
sluffed14308303sluff_ed
sluffing15247303sluffing
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
smudgier1233753smudgier
smuttier1035213smuttier
snaffle13216253snaffle_
snaffled15285213snaffled
snaffles14246043snaffles
snaggier10136303snaggier
snakier112810003sn_akier
snappier1266223snappier
snarkier12336513snarkier
snarlier8278183snarlier
snazzier1642483snazzier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
sniffed14318183sniff_ed
sniffers14257123sniff_ers
sniffiest15236003sniffiest
sniffily17154033sniffily
sniffing15227453sniffing
sniffish1744513sniffish
sniffle13287653sniffle_
sniffled15276443sniffled
snifflers15275053snifflers
sniffles14257723sniffles
snifter10349623sn_ifter
snippier1255793snippier
snobbier1234633snobbier
snoopier10177273snoopier
snootier8278383snootier
snoozier17185193snoozier
snottier8217383snottier
snoutier8206973snoutier
snowier1038793sn_owier
snubber11277733snu_bber
snuff113514043snuff___
snuffbox2341043snuffbox
snuffliest1643503snuffliest
snuffling1643563snuffling
snuffly16305203snuff_ly
snuffs12358533snuff__s
snuffy15356243snuff__y
snugger9318313snu_gger
snuggies10246363snuggies
souffle13306803souffle_
souffled15276193souffled
souffles14298123souffles
soupier93111753sou_pier
spiffied17234823spiffied
spiffies16277993spiffies
spumier1137903spu_mier
spunkier14235823spunkier
spurrier10297693spurrier
staffer13299093staff_er
stiffer13319393stiff_er
stiffie13245773stiffie_
stiffies14258383stiffies
stubbier1235353stubbier
studier82510053stu_dier
studlier935473studlier
stuffed14328973stuff_ed
stuffers14277383stuff_ers
stuffiest15235953stuffiest
stuffily17124163stuffily
stuffing15247843stuffing
stumpier1255883stumpier
stupefier1442653stupefier
sturdier9216963sturdier
suckier133613973s_uckier
sudsier868783s_udsier
sufferer1436063s_ufferer
suffers133113543s_uff_ers
suffice15197573s_uffice
sufficed17205663s_ufficed
sufficers17204533s_ufficers
suffices16208183s_uffices
suffix1935233s_uffi_x
suffixed22214343s_uffixed
suffixes21196353s_uffixes
sulkier113811963s_ulkier
sunnier73412153s_unnier
surfer93515883s_urf_er
surlier72915443s_urlier
tuftier1096603_tuftier
turfier10249793_turfier
unifier102211863un_ifier

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.456391866.2
2DLD Change Limit1461621696.96620982.2
3Display Results1691690.0802112.5
 (SQL Overall)1786911697.50223819.1
 
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.