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 “snaffling” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
snaffling164376(None) 
sniffling1644091sniffling
snuffling1643561snuffling
baffling1756052_baffling
naffing14359032_naff_ing
raffling1567062_raffling
scuffling1843612scuffling
shuffling1933452shuffling
skiffling2043102skiffling
snafuing1235082sna_fuing
snailing92912972sna_iling
snarfing12358662snarf_ing
snarling92513182sna_rling
sniffing15227452sniff_ing
snuffing15256802snuff_ing
staffing15247492staff_ing
waffling1845422_waffling
baffing164011603_baff_ing
chaffing2036323chaff_ing
coffling1736483_coffling
daffing15369733_daff_ing
enabling1138603ena_bling
enameling1246123enameling
gaffing15379733_gaff_ing
gnarling10217603gna_rling
infalling1356243infalling
muffling1765503_muffling
nailing83419963_na_iling
piaffing1733923piaff_ing
piffling1745133_piffling
quaffing2434353quaff_ing
riffling1556113_riffling
ruffling1546093_ruffling
saddling11239593s_addling
sailing83927373s_a_iling
sampling13510643s_ampling
sandaling112010563sandaling
sandling102214413s_andling
sapling103217863s_a_pling
scabbling1634863scabbling
scaffolding2151283scaffolding
scaling103519373sca__ling
scantling12107233scantling
scarfing14309713scarf_ing
sclaffing1843363sclaff_ing
scoffing17275943scoff_ing
scuffing17287113scuff_ing
seafaring1345963seafaring
sealing83528563sea__ling
shackling19286173shackling
shafting15278683sha_fting
shambling1735593shambling
shauling1249393sha_uling
shaveling1646843shaveling
shawling1558223sha_wling
sluffing15247303sluff_ing
snacking153411703sna_cking
snaffle13216253snaffl__e
snaffled15285213snaffl_ed
snaffles14246043snaffl_es
snagging11319373sna_gging
snaking123915303sna__king
snapping13349653sna_pping
snaring83920953sna__ring
snatching1536363snatching
snawing113612483sna__wing
snelling93913563sn_elling
sniggling1244413sniggling
sniveling1336033sniveling
snooling93013473sn_ooling
snoozling19314343snoozling
snufflier1543303snufflier
snuggling1243473snuggling
spackling18266503spackling
spalling113213463spa_lling
spangling1336373spangling
sparkling16226353sparkling
sparling112714533spa_rling
spiffing17237083spiff_ing
spiffying2142753spiffying
stabling112913653sta_bling
staling83925423sta__ling
stalling95116703sta_lling
stapling112813153sta_pling
starling93017123sta_rling
startling1037373startling
stiffing15248703stiff_ing
stifling122110913s_tifling
stuffing15247843stuff_ing
swaddling1543813swaddling
unfailing1337453unfailing
unmuffling1941723unmuffling
waffing173710243_waff_ing
wafflings1943023_wafflings
whiffling2242883whiffling
yaffing17337823_yaff_ing

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 Filter1786911486410.703254183.5
2DLD Change Limit148641966.75022020.9
3Display Results96960.0462087.0
 (SQL Overall)178691967.49923828.6
 
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.