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

110 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
stiffens1424411(None) 
stiffen13286021stiffen_
sniffers14257122sniffers
staffers14247082staffers
stiffed14359582stiffe_d
stiffened1642132stiffened
stiffener1541962stiffener
stiffeners1641782stiffeners
stiffer13319392stiffe_r
stiffest1435682stiffest
stiffies14258382stiffies
stiffing15248702stiffing
stiffness1543552stiffness
stiffs12389962stiff__s
stiflers11238832stiflers
stifles103013392stifle_s
stuffers14277382stuffers
tiffins13327982_tiffins
biffins15358533_biffins
chiffons1943693chiffons
coiffes1546803coiffe_s
differs14339973_differs
griffes14367923griffe_s
griffins1544783griffins
griffons1542573griffons
niffers13287363_niffers
scoffers16286133scoffers
scuffers16307493scuffers
shifters14319863shifters
shippens15316803shippens
sickens134411483s_ickens
siemens938413s_iemens
sifters103714793s_ifters
sirens65318153s_i_rens
sithens1039383s_ithens
skiffles18265713skiffles
skiffless19243053skiffless
skiffs16327013skiff__s
slickens14317263slickens
smidgens12325643smidgens
sniffed14318183sniffe_d
sniffer13318903sniffe_r
sniffing15227453sniffing
snifflers15275053snifflers
sniffles14257723sniffles
sniffs12378843sniff__s
snifters11318613snifters
snuffers14326923snuffers
softens10347623s_oftens
spiffed16257103spiffe_d
spiffies16277993spiffies
spiffing17237083spiffing
spiffs14328473spiff__s
staffed14298283staffe_d
staffer13299093staffe_r
staffing15247493staffing
staffs12349753staff__s
stamens93411483st_amens
steepens10277113steepens
stibines1038153stibines
stickers142913033stickers
sties55132983sti__e_s
stiff114219243stiff___
stiffening1742113stiffening
stiffie13245773stiff_ie
stiffish1745243stiffish
stiffly16235173stiff_ly
stifle93611903stifle__
stifled113511093stifle_d
stifler102911473stifle_r
stifling122110913stifling
stilbene1043613stilbene
stilbenes1143933stilbenes
stiles64328773sti_le_s
stimes85920573sti_me_s
stimies9316563stimie_s
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stipels9418953sti_pels
stipend10386553sti_pend
stipends11304793sti_pends
stipes84524053sti_pe_s
stirpes95011293stirpe_s
stirrers8266943stirrers
stivers103613543sti_vers
stollens835293stollens
stoutens8255273stoutens
strafers11379913strafers
strafes104516003strafe_s
strifes104716583strife_s
stuffed14328973stuffe_d
stuffer13349793stuffe_r
stuffing15247843stuffing
stuffings16233493stuffings
stuffless1543543stuffless
stuffs123810223stuff__s
suffers133113543s_uffers
swiddens1342713swiddens
swifters14277483swifters
tiffany1642663_tiffany
tiffed13368393_tiffe_d
tiffin12327933_tiffin_
tiffing14339383_tiffing
tiffs114414883_tiff__s
titfers10318933_titfers
toffees13327083_toffees
tuffets13266523_tuffets
whiffers2064493whiffers
whiffets2072523whiffets

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.420425454.8
2DLD Change Limit1461621106.89321204.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.35924282.0
 
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.