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

165 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
sniffles1425772(None) 
skiffles18265711skiffles
snaffles14246041snaffles
sniffle13287651sniffle_
sniffled15276441sniffled
sniffler14296831sniffler
snifflers15275051snifflers
snuffles14318411snuffles
piffles15368772_piffles
riffles133911172_riffles
scuffles16287862scuffles
shuffles17297782shuffles
skiffle17225202skiffle_
skiffled19244422skiffled
skiffless19243052skiffless
snaffle13216252snaffle_
snaffled15285212snaffled
sniffed14318182sniff_ed
sniffer13318902sniff_er
sniffers14257122sniffers
sniffier14356642sniffier
sniffiest15236002sniffiest
sniffly16265642sniffl_y
sniffs12378842sniff__s
sniggles10307312sniggles
snuffle13267832snuffle_
snuffled15277032snuffled
snuffler14317412snuffler
snufflers15285222snufflers
souffles14298122souffles
spiffies16277992spiffies
stiffies14258382stiffies
stifles103013392sti_fles
whiffles2034262whiffles
anisoles81010123anisoles
baffles153710683_baffles
biffies152710853_biffies
coffles152610003_coffles
coiffes1546803coiff_es
duffles14308923_duffles
enisles72312603eni_sles
griffes14367923griff_es
jiffies20327473_jiffies
knifes136210213kni_f_es
muffles153910453_muffles
nibbles114011693_nibbles
nickles133713823_nickles
niffer12378443_niff_er
niffers13287363_niffers
nifties102612503_nifties
niggles93512203_niggles
nipples11319663_nipples
piffle14418233_piffle_
piffled16366403_piffled
raffles133611853_raffles
riffle124210233_riffle_
riffled14338603_riffled
riffler13328353_riffler
rifflers14336453_rifflers
rifles94217713_ri_fles
ruffles133512273_ruffles
sanicles10149943sani_cles
scuffle15266893scuffle_
scuffled17256203scuffled
scuffler16286703scuffler
scufflers17285033scufflers
seniles72618023seni__les
shiftless15265303shiftless
shingles123111113shingles
shuffle16276923shuffle_
shuffled18296243shuffled
shuffler17306803shuffler
shufflers18265153shufflers
sickles133417543s_ickles
sidles74721153s_i_dles
siffleur1441833s_iffleur
siffleurs1541643s_iffleurs
similes92915233s_imiles
simples113014943s_imples
singles83520433s_ingles
sizzles15349633s_izzles
skiffs16327013skiff__s
skittles1245763skittles
smiles84522293smi__les
sniff113915863sniff___
sniffable1743773sniffable_
sniffily17154033sniffily
sniffiness1643763sniffiness
sniffing15227453sniffing
sniffish1744513sniffish
sniffling1644093sniffling
sniffy15337193sniff__y
snifter10349623sni_fter
snifters11318613snifters
sniggle9316833sniggle_
sniggled11275743sniggled
sniggler10396113sniggler
snigglers11314593snigglers
sniglet83612413sni_glet
sniglets9276813sni_glets
snipes83917393sni__pes
snitches13148983snitches
sniveled1255463sniveled
sniveler1155253sniveler
snivelers1264533snivelers
snivels10336903snivel_s
snoozles17335563snoozles
snuffed14308073snuff_ed
snuffer13318853snuff_er
snuffers14326923snuffers
snuffier14276943snuffier
snuffiest15246053snuffiest
snufflier1543303snufflier
snuffliest1643503snuffliest
snuffly16305203snuffl_y
snuffs12358533snuff__s
snuggles10306143snuggles
souffle13306803souffle_
souffled15276193souffled
spicules12219803spicules
spiffed16257103spiff_ed
spiffied17234823spiffied
spiffier16255883spiffier
spiffiest17235663spiffiest
spiffs14328473spiff__s
spiles84227913spi__les
spindles112710353spindles
spinules10249333spinules
spittles1038333spittles
stickles142512103stickles
stiffed14359583stiff_ed
stiffen13286023stiff_en
stiffens14244113stiffens
stiffer13319393stiff_er
stiffest1435683stiff_est
stiffie13245773stiffie_
stiffly16235173stiffl_y
stiffness1543553stiffness
stiffs12389963stiff__s
stifle93611903sti_fle_
stifled113511093sti_fled
stifler102911473sti_fler
stiflers11238833sti_flers
stiles64328773sti__les
stipples1247023stipples
stipules1037053stipules
stuffless1543543stuffless
subfiles131710723subfiles
swiftlet1444793swiftlet
swiftlets1542723swiftlets
swindles12319503swindles
swingles12319543swingles
swiples12339643swi_ples
swipples1534843swipples
swizzles1953783swizzles
trifles103814833tri_fles
truffles1485593truffles
unifaces1346393unifaces
unifies102714713uni_fies
unmuffles1772063unmuffles
waffles16329983_waffles
whiffle1933533whiffle_
whiffled2133043whiffled
whiffler2033483whiffler
whifflers2142773whifflers

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 Limit1461621657.61019206.6
3Display Results1651650.0802062.5
 (SQL Overall)1786911658.11022033.4
 
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.