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

167 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
sniffier1435664(None) 
sniffer13318901sniff_er
sniffler14296831sniffler
snuffier14276941snuffier
spiffier16255881spiffier
cliffier1633912cliffier
iffier1236762__iffier
miffier1537022_miffier
niffer12378442_niff_er
niftier10328712_niftier
shiftier1436342shiftier
sniffed14318182sniff_ed
sniffers14257122sniff_ers
sniffiest15236002sniffiest
sniffily17154032sniffily
sniffing15227452sniffing
sniffish1744512sniffish
sniffle13287652sniffle_
sniffled15276442sniffled
snifflers15275052snifflers
sniffles14257722sniffles
snifter10349622sni_fter
snippier1255792snippier
snuffer13318852snuff_er
snuffler14317412snuffler
snufflier1543302snufflier
spiffied17234822spiffied
spiffies16277992spiffies
squiffier2442842squiffier
stiffer13319392stiff_er
stiffie13245772stiffie_
stiffies14258382stiffies
stuffier14336622stuffier
unifier102211862uni_fier
biffies152710853_biffies
buffier1568403_buffier
chaffier1935473chaffier
chuffier1934543chuffier
daffier1457833_daffier
deifier113013123dei_fier
differ133910843_diff_er
draffier1574323draffier
driftier1275123driftier
edifier11309263edi_fier
fluffier13264333fluffier
gruffier1544703gruffier
huffier1637493_huffier
jiffies20327473_jiffies
knifer13598563kni_f_er
niffers13287363_niff_ers
nifties102612503_nifties
nippier11319833_nippier
nittier73512243_nittier
ossifier111196273ossi_fier
puffier1547973_puffier
reifier103414523rei_fier
riffler13328353_riffler
satisfier1243733satisfier
scoffer15317023scoff_er
scruffier1743303scruffier
scuffer15328883scuff_er
scuffler16286703scuffler
scurfier13267053scurfier
shifter132911083shi_fter
shinier104113143shi_nier
shirtier1137943shirtier
shittier1137313shittier
shuffler17306803shuffler
siffleur1441833s_iffleur
sifter94516233s_i_fter
signifier1345713signi_fier
silkier114411643s_ilkier
sillier74017593s_illier
siltier73413863s_iltier
sissier73711363s_issier
sizier1514813393s_i_zier
skiddier1464193skiddier
skiffle17225203skiffle_
skiffled19244423skiffled
skiffles18265713skiffles
skimpier1634293skimpier
skinnier1264893skinnier
slimier93212013sli_mier
slimsier1085213slimsier
slinkier12206933slinkier
slippier1256543slippier
slittier837003slittier
smirkier1444433smirkier
snaffle13216253snaffle_
snaffled15285213snaffled
snaffles14246043snaffles
snaggier10136303snaggier
snakier112810003sn_akier
snappier1266223snappier
snarkier12336513snarkier
snarlier8278183snarlier
snazzier1642483snazzier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
snicker133012673sni_cker
snider74413913sni__der
sniff113915863sniff___
sniffiness1643763sniffiness
sniffling1644093sniffling
sniffly16265643sniff_ly
sniffs12378843sniff__s
sniffy15337193sniff__y
snifters11318613sni_fters
snigger9328373sni_gger
sniggler10396113sniggler
sniper84413643sni__per
snipper113911333sni_pper
snitcher13157373snitcher
sniveler1155253sniveler
snobbier1234633snobbier
snoopier10177273snoopier
snootier8278383snootier
snoozier17185193snoozier
snottier8217383snottier
snoutier8206973snoutier
snowier1038793sn_owier
snubbier1244993snubbier
snuffed14308073snuff_ed
snuffers14326923snuff_ers
snuffiest15246053snuffiest
snuffily17124323snuffily
snuffing15256803snuffing
snuffle13267833snuffle_
snuffled15277033snuffled
snufflers15285223snufflers
snuffles14318413snuffles
spicier115112463spi_cier
spiffed16257103spiff_ed
spiffiest17235663spiffiest
spiffily19153483spiffily
spiffing17237083spiffing
spikier13369983spi_kier
spinier93715163spi_nier
spirier93214073spi_rier
spitfire1343053spitfire
staffer13299093staff_er
stickier14229763stickier
stiffed14359583stiff_ed
stiffen13286023stiff_en
stiffener1541963stiffener
stiffing15248703stiffing
stiffish1745243stiffish
stifler102911473sti_fler
stillier868823stillier
stingier9279123stingier
stinkier12278543stinkier
stuffer13349793stuff_er
suffer124314513s_uff_er
sufficer16225823s_ufficer
surfier102613543s_urfier
swifter13318053swi_fter
swimmier15174313swimmier
swingier12267003swingier
swirlier1135213swirlier
swishier1434563swishier
unified112413573uni_fied
unifiers11237173uni_fiers
unifies102714713uni_fies
whiffer19105323whiff_er
whiffler2033483whiffler
wiftier13297733_wiftier

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.423422437.4
2DLD Change Limit1461621677.50019488.3
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.98622375.5
 
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.