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
sniffle13287641sniffle
sniffy15337191sniff_y
snuffly16305191snuffly
stiffly16235171stiffly
skiffle17225202skiffle
snaffle13216242snaffle
snidely1136802snidely
sniff113915862sniff__
sniffed14318182sniffed
sniffer13318902sniffer
sniffled15276432sniffled
sniffler14296822sniffler
sniffles14257712sniffles
sniffs12378842sniff_s
snuffily17124312snuffily
snuffle13267822snuffle
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
scuffle15266883scuffle
senilely1146093senilely
shadfly1733783shadfly
shiftily1744543shiftily
shifty15409253shi_fty
shily115222013shi__ly
shingly143210803shingly
shinily13268933shinily
shoofly1634343shoofly
shuffle16276913shuffle
sickly153110483s_ickly
silly84527613s_i_lly
simply133010523s_imply
sinful938803sinful_
sinfully1445603sinfully
singly104015853s_ingly
skiff153612803skiff__
skiffled19244423skiffled
skiffles18265703skiffles
skiffs16327013skiff_s
slickly1635853slickly
slily85820033sli__ly
slimily1247713slimily
slimly11408903sli_mly
snaffled15285203snaffled
snaffles14246033snaffles
snakily1436913snakily
snarly93815003sn_arly
sniffable1743773sniffable
sniffers14257123sniffers
sniffier14356633sniffier
sniffing15227453sniffing
sniffish1744503sniffish
sniffishly2251873sniffishly
snifflers15275043snifflers
sniffling1644083sniffling
snifter10349623snifter
sniggle9316833sniggle
snippily1543573snippily
snippy1374843sni_ppy
snivel9368853snivel_
snivels10336903snivels
snowily1336883snowily
snuff113514043snuff__
snuffed14308063snuffed
snuffer13318843snuffer
snuffled15277023snuffled
snuffler14317403snuffler
snuffles14318403snuffles
snuffs12358523snuff_s
snugly1055663sn_ugly
softly12457763s_oftly
souffle13306793souffle
spicily1438653spicily
spiff133616403spiff__
spiffed16257103spiffed
spiffs14328473spiff_s
spikily1635873spikily
spindly13257383spindly
squiffy2542563squiff_y
stiff114219243stiff__
stiffed14359583stiffed
stiffen13286023stiffen
stiffer13319393stiffer
stiffie13245773stiffie
stiffs12389963stiff_s
stifle93611903sti_fle
stilly93714073sti_lly
stuffily17124163stuffily
stuffy15317083stuff_y
swirly12439243swi_rly
swithly1634443swithly
unfitly1335573unfitly
unify113611113uni_f_y
unwifely1743603unwifely
waffly18305433_waffly
whiffle1933533whiffle
wifely15429423_wifely

Search took 6 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.1601116818.8
2DLD Change Limit1340271245.76323256.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911245.96929936.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.