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

179 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
stuffier1433662(None) 
snuffier14276941snuffier
stuffer13349791stuff_er
buffier1568402_buffier
chuffier1934542chuffier
fluffier13264332fluffier
gruffier1544702gruffier
huffier1637492_huffier
puffier1547972_puffier
scruffier1743302scruffier
scuffer15328882scuff_er
scuffler16286702scuffler
scurfier13267052scurfier
shuffler17306802shuffler
sniffier14356642sniffier
snuffer13318852snuff_er
snuffler14317412snuffler
snufflier1543302snufflier
spiffier16255882spiffier
squiffier2442842squiffier
staffer13299092staff_er
stiffer13319392stiff_er
stiffie13245772stiffie_
stiffies14258382stiffies
stubbier1235352stubbier
studier82510052stu_dier
studlier935472studlier
stuffed14328972stuff_ed
stuffers14277382stuff_ers
stuffiest15235952stuffiest
stuffily17124162stuffily
stuffing15247842stuffing
stumpier1255882stumpier
stupefier1442652stupefier
sturdier9216962sturdier
suffer124314512s_uff_er
sufficer16225822s_ufficer
surfier102613542s_urfier
tuftier1096602_tuftier
turfier10249792_turfier
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
miffier1537023_miffier
muffler15398343_muffler
puffer144610733_puff_er
ruffler13369723_ruffler
rufflier1434013_rufflier
satisfier1243733satisfier
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
sniffer13318903sniff_er
sniffler14296833sniffler
snubbier1244993snubbier
snuffed14308073snuff_ed
snuffers14326923snuff_ers
snuffiest15246053snuffiest
snuffily17124323snuffily
snuffing15256803snuffing
snuffle13267833snuffle_
snuffled15277033snuffled
snufflers15285223snufflers
snuffles14318413snuffles
souffle13306803souffle_
souffled15276193souffled
souffles14298123souffles
soupier93111753sou_pier
spiffied17234823spiffied
spiffies16277993spiffies
spumier1137903spu_mier
spunkier14235823spunkier
spurrier10297693spurrier
staffed14298283staff_ed
staffers14247083staff_ers
staffing15247493staffing
staggier10167513staggier
stagier83513443st_agier
stalkier1257073stalkier
starrier8279463starrier
steadier937313steadier
steamier1048303steamier
steelier839183steelier
stemmier1245253stemmier
stickier14229763stickier
stiffed14359583stiff_ed
stiffen13286023stiff_en
stiffener1541963stiffener
stiffing15248703stiffing
stiffish1745243stiffish
stifler102911473st_ifler
stillier868823stillier
stingier9279123stingier
stinkier12278543stinkier
stockier14217253stockier
stodgier1034223stodgier
stonier72013793st_onier
stormier1036103stormier
strafer103912463straf_er
strawier1137493strawier
stripier1058863stripier
stubblier1343203stubblier
stuccoer1252803stuccoer
studdie9195273studdie_
studdies10207073studdies
studfish1544523studfish
studied9268693stu_died
studiers9236623stu_diers
studies82413863stu_dies
stuff113817053stuff___
stuffiness1643693stuffiness
stuffings16233493stuffings
stuffless1543543stuffless
stuffs123810223stuff__s
stuffy15317083stuff__y
stuiver10447083stu_iver
stumbler1235813stumbler
stumper113610093stu_mper
stunner7349193stu_nner
stupefied1542673stupefied
stupefiers1552003stupefiers
stupefies1443833stupefies
stupider1133913stupider
sturdied10215963sturdied
sturdies92110273sturdies
stutter72911463stu_tter
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
taffies133012693_taffies
toffies133210213_toffies
tubbier11237743_tubbier
tuffet122612083_tuff_et
tufter9319933_tu_fter

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621796.39022873.6
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.87625987.6
 
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.