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 “sniffily” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
sniffily1715403(None) 
sniffly16265641sniff_ly
snuffily17124321snuffily
spiffily19153481spiffily
niftily1335752_niftily
shiftily1744552shiftily
sniffier14356642sniffier
sniffing15227452sniffing
sniffish1744512sniffish
sniffishly2251872sniffishly
sniffle13287652sniff_le
sniffy15337192sniff__y
snippily1543572snippily
snuffly16305202snuff_ly
stiffly16235172stiff_ly
stuffily17124162stuffily
daffily1735143_daffily
fluffily1652923fluffily
gruffily1863083gruffily
huffily1934693_huffily
nippily1444713_nippily
puffily1834843_puffily
scruffily2041883scruffily
shinily13268933shi_nily
silkily14236963s_ilkily
sillily10209783s_illily
sinfully1445613sinfully
skiffle17225203skiff_le
skimpily1963053skimpily
slimily1247713sli_mily
slinkily1534853slinkily
slippily1544193slippily
smirkily1753333smirkily
snaffle13216253snaff_le
snakily1436913sn_akily
snappily1544323snappily
snarkily1534583snarkily
sneakily1544423sneakily
snidely1136813sni_dely
sniff113915863sniff___
sniffable1743773sniffable
sniffed14318183sniff_ed
sniffer13318903sniff_er
sniffers14257123sniffers
sniffiest15236003sniffiest
sniffled15276443sniffled
sniffler14296833sniffler
sniffles14257723sniffles
sniffling1644093sniffling
sniffs12378843sniff__s
snobbily1544233snobbily
snoopily1345553snoopily
snootily1136253snootily
snottily1145553snottily
snowily1336883sn_owily
snuffier14276943snuffier
snuffing15256803snuffing
snuffle13267833snuff_le
snuffy15356243snuff__y
spicily1438653spi_cily
spiffied17234823spiffied
spiffier16255883spiffier
spiffies16277993spiffies
spiffing17237083spiffing
spiffy17326223spiff__y
spikily1635873spi_kily
stickily1736083stickily
stiffie13245773stiffi_e
stiffies14258383stiffies
stiffing15248703stiffing
stiffish1745243stiffish
stingily1236793stingily
swiftly1633733swi_ftly
swimmily1842713swimmily

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.420425454.8
2DLD Change Limit146162747.56319325.9
3Display Results74740.0302466.7
 (SQL Overall)178691748.01322300.1
 
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.