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

124 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
sniffly1626564(None) 
sniffily17154031sniffily
sniffle13287651sniffle
sniffy15337191sniff_y
snuffly16305201snuffly
stiffly16235171stiffly
skiffle17225202skiffle
snaffle13216252snaffle
snidely1136812snidely
sniff113915862sniff__
sniffed14318182sniffed
sniffer13318902sniffer
sniffled15276442sniffled
sniffler14296832sniffler
sniffles14257722sniffles
sniffs12378842sniff_s
snuffily17124322snuffily
snuffle13267832snuffle
snuffy15356242snuff_y
spiffily19153482spiffily
spiffy17326222spiff_y
swiftly1633732swiftly
biffy164711133_biff_y
bluffly1833433bluffly
briefly1534573briefly
chiefly1834103chiefly
cliffy17435243cliff_y
gruffly17413893gruffly
iffy135312283__iff_y
jiffy21458313_jiff_y
liefly1266363_liefly
miffy163910203_miff_y
nicely1139493_nicely
niffer12378443_niffer
niftily1335753_niftily
nifty115211633_ni_fty
niggly11418913_niggly
nimbly13388773_nimbly
piffle14418233_piffle
rifely123710033_rifely
riffle124210233_riffle
ruffly15336673_ruffly
safely12249393s_afely
saintly1039343saintly
sandfly1435643sandfly
sawfly1535133s_awfly
scuffle15266893scuffle
senilely1146103senilely
shadfly1733783shadfly
shiftily1744553shiftily
shifty15409263shi_fty
shily115222013shi__ly
shingly143210813shingly
shinily13268933shinily
shoofly1634353shoofly
shuffle16276923shuffle
sickly153110483s_ickly
silly84527623s_i_lly
simply133010523s_imply
sinful938803sinful_
sinfully1445613sinfully
singly104015853s_ingly
skiff153612803skiff__
skiffled19244423skiffled
skiffles18265713skiffles
skiffs16327013skiff_s
slickly1635853slickly
slily85820033sli__ly
slimily1247713slimily
slimly11408903sli_mly
snaffled15285213snaffled
snaffles14246043snaffles
snakily1436913snakily
snarly93815003sn_arly
sniffable1743773sniffable
sniffers14257123sniffers
sniffier14356643sniffier
sniffing15227453sniffing
sniffish1744513sniffish
sniffishly2251873sniffishly
snifflers15275053snifflers
sniffling1644093sniffling
snifter10349623snifter
sniggle9316833sniggle
snippily1543573snippily
snippy1374843sni_ppy
snivel9368853snivel_
snivels10336903snivels
snowily1336883snowily
snuff113514043snuff__
snuffed14308073snuffed
snuffer13318853snuffer
snuffled15277033snuffled
snuffler14317413snuffler
snuffles14318413snuffles
snuffs12358533snuff_s
snugly1055663sn_ugly
softly12457763s_oftly
souffle13306803souffle
spicily1438653spicily
spiff133616403spiff__
spiffed16257103spiffed
spiffs14328473spiff_s
spikily1635873spikily
spindly13257383spindly
squiffy2542573squiff_y
stiff114219243stiff__
stiffed14359583stiffed
stiffen13286023stiffen
stiffer13319393stiffer
stiffie13245773stiffie
stiffs12389963stiff_s
stifle93611903sti_fle
stilly93714093sti_lly
stuffily17124163stuffily
stuffy15317083stuff_y
swirly12439253swi_rly
swithly1634443swithly
unfitly1335573unfitly
unify113611113uni_f_y
unwifely1743603unwifely
waffly18305433_waffly
whiffle1933533whiffle
wifely15429423_wifely

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271246.23621492.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.43827755.7
 
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.