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

137 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
stiffie1324577(None) 
stiffies14258381stiffies
skiffle17225202skiffle
sniffier14356642sniffier
sniffle13287652sniffle
spiffied17234822spiffied
spiffier16255882spiffier
spiffies16277992spiffies
stiff114219242stiff__
stiffed14359582stiffed
stiffen13286022stiffen
stiffer13319392stiffer
stiffing15248702stiffing
stiffish1745242stiffish
stiffly16235172stiffly
stiffs12389962stiff_s
stifle93611902sti_fle
stuffier14336622stuffier
tiffin12327932_tiffin
biffies152710853_biffies
biffin14369103_biffin
cliffier1633913cliffier
coiffe1447043coiff_e
griffe13438093griff_e
griffin1434513griffin
iffier1236763__iffier
jiffies20327473_jiffies
miffier1537023_miffier
piffle14418233_piffle
riffle124210233_riffle
satisfice1442943satisfice
satisfied1343873satisfied
satisfier1243733satisfier
satisfies1245323satisfies
scuffle15266893scuffle
shiftier1436343shiftier
shuffle16276923shuffle
sickie123715743s_ickie
silkie103313403s_ilkie
skiff153612803skiff__
skiffled19244423skiffled
skiffles18265713skiffles
skiffs16327013skiff_s
snaffle13216253snaffle
sniff113915863sniff__
sniffed14318183sniffed
sniffer13318903sniffer
sniffiest15236003sniffiest
sniffily17154033sniffily
sniffing15227453sniffing
sniffish1744513sniffish
sniffled15276443sniffled
sniffler14296833sniffler
sniffles14257723sniffles
sniffly16265643sniffly
sniffs12378843sniff_s
sniffy15337193sniff_y
snuffier14276943snuffier
snuffle13267833snuffle
soffit1237883s_offit
softie93312483s_oftie
souffle13306803souffle
spiff133616403spiff__
spiffed16257103spiffed
spiffiest17235653spiffiest
spiffily19153483spiffily
spiffing17237083spiffing
spiffs14328473spiff_s
spiffy17326223spiff_y
spitfire1343053spitfire
squiffier2442843squiffier
staff113817713staff__
staffed14298283staffed
staffer13299093staffer
staffing15247493staffing
staffs12349753staff_s
staggie9138463staggie
steelie7310213steelie
stibine938663stibine
stibnite1044073stibnite
stichic1446243stichic
stickier14229763stickier
stickies142211973stickies
stickit1339463stickit
stickle132410973stickle
stiffened1642133stiffened
stiffener1541963stiffener
stiffens14244113stiffens
stiffest1435683stiffest
stiffness1543553stiffness
stifled113511093stifled
stifler102911473stifler
stifles103013393stifles
stifling122110913stifling
stilbite1045423stilbite
stile54931573sti__le
stillier868823stillier
stime76521803sti__me
stimied10310623sti_mied
stimies9316563sti_mies
stingier9279123stingier
stinkier12278543stinkier
stipe76523373sti__pe
stipple1146623stipple
stipule936723stipule
stithied1235303stithied
stithies1139233stithies
stogie7311323st_ogie
stoolie739723stoolie
stourie7469353stourie
strafe95215983straf_e
strife95318363strif_e
studdie9195273studdie
stuff113817053stuff__
stuffed14328973stuffed
stuffer13349793stuffer
stuffiest15235953stuffiest
stuffily17124163stuffily
stuffing15247843stuffing
stuffs123810223stuff_s
stuffy15317083stuff_y
stymie1137623st_ymie
suffice15197573s_uffice
suffix1935233s_uffix
taffia12286903_taffia
taffies133012693_taffies
tiff104727723_tiff__
tiffed13368393_tiffed
tiffined1543403_tiffined
tiffing14339383_tiffing
tiffins13327983_tiffins
tiffs114414883_tiff_s
tittie63213153_tittie
toffee123311013_toffee
toffies133210213_toffies
waffie15338563_waffie
whiffle1933533whiffle

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 Filter1786911340270.796224486.2
2DLD Change Limit1340271377.94016880.0
3Display Results1371370.0602283.3
 (SQL Overall)1786911378.79620315.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.