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

163 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
sniffled1527643(None) 
skiffled19244421skiffled
snaffled15285201snaffled
sniffed14318181sniff_ed
sniffle13287641sniffle_
sniffler14296821sniffler
sniffles14257711sniffles
snuffled15277021snuffled
piffled16366402_piffled
riffled14338602_riffled
scuffled17256192scuffled
shuffled18296232shuffled
skiffle17225202skiffle_
skiffles18265702skiffles
snaffle13216242snaffle_
snaffles14246032snaffles
sniffer13318902sniff_er
sniffier14356632sniffier
snifflers15275042snifflers
sniffly16265642sniffl_y
sniggled11275742sniggled
sniveled1255462sniveled
snuffed14308062snuff_ed
snuffle13267822snuffle_
snuffler14317402snuffler
snuffles14318402snuffles
souffled15276182souffled
spiffed16257102spiff_ed
spiffied17234822spiffied
stiffed14359582stiff_ed
stifled113511092sti_fled
whiffled2133042whiffled
baffled16418063_baffled
biffed15449883_biff_ed
coffled16297363_coffled
coiffed1635413coiff_ed
enisled82510223eni_sled
knifed14528123kni_f_ed
miffed15398713_miff_ed
muffled16377783_muffled
naffed13408333_naff_ed
nibbled12389073_nibbled
nickled144010443_nickled
niffer12378443_niff_er
niffered1544143_niffered
niggled10319203_niggled
nilled73919453_ni_lled
nippled12307643_nippled
piffle14418233_piffle_
piffles15368763_piffles
raffled14429083_raffled
riffed133811563_riff_ed
riffle124210233_riffle_
riffler13328353_riffler
riffles133911163_riffles
rifled104115003_ri_fled
ruffled14369153_ruffled
sailed74327763sai__led
scoffed16266183scoff_ed
scuffed16298243scuff_ed
scuffle15266883scuffle_
scuffler16286693scuffler
scuffles16287853scuffles
seriffed1594973seriff_ed
shifted14359973shi_fted
shilled113313623shi_lled
shingled13358313shingled
shuffle16276913shuffle_
shuffler17306793shuffler
shuffles17297773shuffles
sickled144713433s_ickled
sidled84215173s_i_dled
siffleur1441833s_iffleur
sifted104313673s_i_fted
singled93914683s_ingled
sizzled16367883s_izzled
skiffless19243043skiffless
skilled123110863ski_lled
skirled12348183ski_rled
sluffed14308303sluff_ed
smiled93716433smi__led
snafued1134933sn_afued
snailed83811923sn_ailed
snarfed11378753snarf_ed
snarled83612353sn_arled
snelled83313043sn_elled
snibbed12325633sni_bbed
snicked143811633sni_cked
sniff113915863sniff___
sniffable1743773sniffable_
sniffers14257123sniffers
sniffiest15235993sniffiest
sniffily17154033sniffily
sniffing15227453sniffing
sniffish1744503sniffish
sniffling1644083sniffling
sniffs12378843sniff__s
sniffy15337193sniff__y
snifter10349623sni_fter
sniggle9316833sniggle_
sniggler10396113sniggler
sniggles10307313sniggles
sniglet83612413sni_glet
sniped94913483sni__ped
snipped123510043sni_pped
snitched14166863snitched
sniveler1155253sniveler
snivelled1353993snivelled
snooled84513933sn_ooled
snoozled18344493snoozled
snuffer13318843snuff_er
snuffier14276933snuffier
snufflers15285213snufflers
snufflier1543293snufflier
snuffly16305193snuffl_y
snuggled11234953snuggled
soiled73822473soi__led
souffle13306793souffle_
souffleed16272893souffleed
souffles14298113souffles
spieled104811883spi_eled
spiffier16255883spiffier
spiffies16277983spiffies
spiled94621993spi__led
spilled103613623spi_lled
spindled12287643spindled
spiraled1137723spiraled
squiffed2433723squiff_ed
staffed14298283staff_ed
stickled15298973stickled
stiffen13286023stiff_en
stiffened1642133stiffened
stiffer13319393stiff_er
stiffie13245773stiffie_
stiffies14258373stiffies
stiffly16235173stiffl_y
stifle93611903sti_fle_
stifler102911463sti_fler
stifles103013383sti_fles
stilled83314773sti_lled
stippled1345303stippled
stipuled1134453stipuled
stuffed14328973stuff_ed
swiftlet1444793swiftlet
swilled113611833swi_lled
swindled13307623swindled
swingled13337433swingled
swirled11308223swi_rled
swiveled1544163swiveled
swizzled2053013swizzled
tiffed13368393_tiff_ed
trifled113711963tri_fled
truffled1563993truffled
unfilled1298383unfilled
unified112413573uni_fied
unmuffled1872343unmuffled
unrifled1237423unrifled
unruffled1672923unruffled
waffled17357523_waffled
whiffed2064473whiff_ed
whiffle1933533whiffle_
whiffler2033483whiffler
whiffles2034263whiffles

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 Filter1786911461620.1601116818.8
2DLD Change Limit1461621636.34323043.0
3Display Results1631630.0602716.7
 (SQL Overall)1786911636.56327227.0
 
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.