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 “spiffier” 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
spiffier1625588(None) 
sniffier14356641sniffier
spiffied17234821spiffied
spiffies16277991spiffies
cliffier1633912cliffier
iffier1236762__iffier
miffier1537022_miffier
puffier1547972_puffier
shiftier1436342shiftier
sniffer13318902sniff_er
sniffler14296832sniffler
snuffier14276942snuffier
spicier115112462spi_cier
spiffed16257102spiff_ed
spiffiest17235662spiffiest
spiffily19153482spiffily
spiffing17237082spiffing
spikier13369982spi_kier
spinier93715162spi_nier
spirier93214072spi_rier
spitfire1343052spitfire
squiffier2442842squiffier
stiffer13319392stiff_er
stiffie13245772stiffie_
stiffies14258382stiffies
stuffier14336622stuffier
biffies152710853_biffies
buffier1568403_buffier
chaffier1935473chaffier
chuffier1934543chuffier
daffier1457833_daffier
deifier113013123dei_fier
differ133910843_diff_er
draffier1574323draffier
driftier1275123driftier
edifier11309263edi_fier
fluffier13264333fluffier
gruffier1544703gruffier
huffier1637493_huffier
jiffies20327473_jiffies
niffer12378443_niff_er
niftier10328713_niftier
ossifier111196273ossi_fier
piaffer15104443_piaffer
pickier153912973_pickier
piffle14418233_piffle_
piffled16366403_piffled
piffles15368773_piffles
piggier113510003_piggier
pilfer1139163_pilf_er
pinier84024693_pi_nier
pipier104913983_pi_pier
pithier123010293_pithier
pitier84019823_pi_tier
puffer144610733_puff_er
reifier103414523rei_fier
riffler13328353_riffler
satisfier1243733satisfier
scoffer15317023scoff_er
scruffier1743303scruffier
scuffer15328883scuff_er
scuffler16286703scuffler
scurfier13267053scurfier
shifter132911083shi_fter
shinier104113143shi_nier
shirtier1137943shirtier
shittier1137313shittier
shuffler17306803shuffler
siffleur1441833s_iffleur
sifter94516233s_i_fter
silkier114411643s_ilkier
sillier74017593s_illier
siltier73413863s_iltier
sissier73711363s_issier
sizier1514813393s_i_zier
skiddier1464193skiddier
skiffle17225203skiffle_
skiffled19244423skiffled
skiffles18265713skiffles
skimpier1634293skimpier
skinnier1264893skinnier
slimier93212013sli_mier
slimsier1085213slimsier
slinkier12206933slinkier
slippier1256543slippier
slittier837003slittier
smirkier1444433smirkier
sniffed14318183sniff_ed
sniffers14257123sniff_ers
sniffiest15236003sniffiest
sniffily17154033sniffily
sniffing15227453sniffing
sniffish1744513sniffish
sniffle13287653sniffle_
sniffled15276443sniffled
snifflers15275053snifflers
sniffles14257723sniffles
snifter10349623sni_fter
snippier1255793snippier
snuffer13318853snuff_er
snuffler14317413snuffler
snufflier1543303snufflier
spacier114011633sp_acier
sparkier14298033sparkier
sparrier10329143sparrier
specifier1645683specifier
speedier1146623speedier
spendier1147143spendier
spherier1337783spherier
spicer104719313spi__cer
spider94516803spi__der
spiderier1244653spiderier
spieler93111233spi_eler
spier75728033sp___ier
spiff133616403spiff___
spiffiness1842983spiffiness
spiffs14328473spiff__s
spiffy17326223spiff__y
spiffying2142753spiffying
spiker124315663spi__ker
spiller92914333spi_ller
spindler11297983spindler
spindlier1253873spindlier
spinifex2042053spinifex
spinner93912263spi_nner
spinnies103210543spinnies
spinster1036683spinster
spitfires1442903spitfires
spitter94015183spi_tter
spongier1135743spongier
spoofer12368723spoof_er
spookier14175493spookier
spoonier10167653spoonier
sportier102010053sportier
spottier10207313spottier
sprier84119063sp__rier
spriggier1343843spriggier
springier1236023springier
sprucier1254793sprucier
spumier1137903sp_umier
spunkier14235823spunkier
spurrier10297693spurrier
staffer13299093staff_er
stickier14229763stickier
stiffed14359583stiff_ed
stiffen13286023stiff_en
stiffener1541963stiffener
stiffing15248703stiffing
stiffish1745243stiffish
stifler102911473sti_fler
stillier868833stillier
stingier9279123stingier
stinkier12278543stinkier
stuffer13349793stuff_er
suffer124314513s_uff_er
sufficer16225823s_ufficer
surfier102613543s_urfier
swifter13318053swi_fter
swimmier15174313swimmier
swingier12267003swingier
swirlier1135213swirlier
swishier1434563swishier
typifier1643403typi_fier
unifier102211863uni_fier
whiffer19105323whiff_er
whiffler2033483whiffler
wiftier13297733_wiftier

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.453394461.4
2DLD Change Limit1461621677.53319402.9
3Display Results1671670.0632650.8
 (SQL Overall)1786911678.04922200.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.