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

114 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
stiffest143568(None) 
sniffiest15236002sniffiest
spiffiest17235662spiffiest
stiffed14359582stiffe_d
stiffen13286022stiffe_n
stiffens14244112stiffens
stiffer13319392stiffe_r
stiffies14258382stiffies_
stiffish1745242stiffish
stiffness1543552stiffness
stiffs12389962stiff_s_
stifles103013392stifles_
stillest8311072stillest
stuffiest15235952stuffiest
swiftest1434352swiftest
bluffest1664643bluffest
briefest1335893briefest
buffest15298643_buffest
chiefest1645313chiefest
chuffest1944193chuffest
cliffiest1743953cliffiest
coiffes1546803coiffes_
deffest14308803_deffest
griffes14367923griffes_
gruffest1544593gruffest
iffiest1337963__iffiest
infest93315433__infest
liefest1038443_liefest
miffiest1637133_miffiest
rifest93114583_ri_fest
safest95016603s__afest
shiest95821533shi__est
shiftiest1537373shiftiest
shiniest113212503shiniest
sickest131813793s_ickest
siziest16311473s_iziest
skiffles18265713skiffles_
skiffless19243053skiffless
skiffs16327013skiff_s_
slickest14229253slickest
sliest66621963sli__est
slimiest10310753slimiest
slimmest1235903slimmest
slugfest1244923slugfest
snidest8310913sni_dest
sniffed14318183sniffe_d
sniffer13318903sniffe_r
sniffers14257123sniffers
sniffish1744513sniffish
sniffles14257723sniffles_
sniffs12378843sniff_s_
snuffiest15246053snuffiest
softest10310603s_oftest
songfest1236843songfest
spiciest122711613spiciest
spiffed16257103spiffe_d
spiffies16277993spiffies_
spiffs14328473spiff_s_
spikiest14259543spikiest
spiniest102813233spiniest
spiriest102513463spiriest
squiffiest2542663squiffiest
stablest103312943stablest
staffed14298283staffe_d
staffer13299093staffe_r
staffers14247083staffers
staffs12349753staff_s_
stagiest91613413stagiest
staidest939803staidest
stalest73720173st_alest
starkest1239723starkest
stedfast1243643stedfast
steepest1038123steepest
sternest8314433sternest
stickiest15229603stickiest
sties55132983sti__es_
stiff114219243stiff___
stiffened1642133stiffened
stiffener1541963stiffener
stiffie13245773stiff_ie
stiffing15248703stiffing
stiffly16235173stiff_ly
stifle93611903stifle__
stifled113511093stifle_d
stifler102911473stifle_r
stiflers11238833stiflers
stiles64328773sti_les_
stilliest939223stilliest
stimes85920573sti_mes_
stimies9316563stimies_
stingiest10209773stingiest
stinkiest13198463stinkiest
stipes84524053sti_pes_
stirpes95011293stirpes_
stoniest8413543stoniest
stoutest837613stoutest
strafes104516003strafes_
strictest1147293strictest
strifes104716583strifes_
stripiest1138023stripiest
stuffed14328973stuffe_d
stuffer13349793stuffe_r
stuffers14277383stuffers
stuffless1543543stuffless
stuffs123810223stuff_s_
surfiest112414433surfiest
tidiest83514873_tidiest
tiffed13368393_tiffe_d
tiffs114414883_tiff_s_
tiniest73020123_tiniest
tuffet122612083_tuffe_t
tuffets13266523_tuffets
whiffet1965343whiffe_t
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.733243780.4
2DLD Change Limit1461621147.12620511.1
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.90522604.8
 
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.