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

140 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
skiffles1826571(None) 
skiffle17225201skiffle_
skiffled19244421skiffled
skiffless19243051skiffless
sniffles14257721sniffles
piffles15368762_piffles
riffles133911162_riffles
scuffles16287862scuffles
shuffles17297782shuffles
skiffs16327012skiff__s
skittles1245762skittles
snaffles14246042snaffles
sniffle13287652sniffle_
sniffled15276442sniffled
sniffler14296832sniffler
snifflers15275052snifflers
snuffles14318412snuffles
souffles14298122souffles
spiffies16277992spiffies
stiffies14258382stiffies
stifles103013392sti_fles
whiffles2034262whiffles
baffles153710683_baffles
biffies152710853_biffies
coffles152610003_coffles
coiffes1546803coiff_es
duffles14308923_duffles
griffes14367923griff_es
jiffies20327473_jiffies
kibbles153510253_kibbles
kindles123614843_kindles
kirtles11309663_kirtles
kittles113012493_kittles
muffles153910453_muffles
piffle14418233_piffle_
piffled16366403_piffled
raffles133611843_raffles
riffle124210233_riffle_
riffled14338603_riffled
riffler13328353_riffler
rifflers14336443_rifflers
rifles94217703_ri_fles
ruffles133512273_ruffles
scuffle15266893scuffle_
scuffled17256203scuffled
scuffler16286703scuffler
scufflers17285033scufflers
shiftless15265303shiftless
shingles123111113shingles
shuffle16276923shuffle_
shuffled18296243shuffled
shuffler17306803shuffler
shufflers18265153shufflers
sickles133417543s_ickles
sidles74721153s_i_dles
siffleur1441833s_iffleur
siffleurs1541643s_iffleurs
similes92915233s_imiles
simples113014943s_imples
singles83520433s_ingles
sizzles15349633s_izzles
skatoles1236143skatoles
skiable1338883skiable_
skies95026833ski___es
skiff153612803skiff___
skiffling2043103skiffling
skilled123110863ski_lled
skilless12246763ski_lless
skillet113512153ski_llet
skillets12226823ski_llets
skills104313923ski__lls
skinfuls1543093skinfuls
skinless12216973ski_nless
skirled12348183ski_rled
skirls10449823ski_rl_s
skirtless13254423skirtless
skites104418043ski__tes
skittle1135533skittle_
skives134113943ski__ves
skivvies18112883skivvies
smiles84522293smi__les
snaffle13216253snaffle_
snaffled15285213snaffled
sniffed14318183sniff_ed
sniffer13318903sniff_er
sniffers14257123sniffers
sniffier14356643sniffier
sniffiest15236003sniffiest
sniffly16265643sniffl_y
sniffs12378843sniff__s
sniggles10307313sniggles
snuffle13267833snuffle_
snuffled15277033snuffled
snuffler14317413snuffler
snufflers15285223snufflers
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
trifles103814823tri_fles
truffles1485593truffles
waffles16329983_waffles
whiffle1933533whiffle_
whiffled2133043whiffled
whiffler2033483whiffler
whifflers2142773whifflers

Search took 8 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 Limit1461621407.47019566.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.93622516.5
 
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.