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

137 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
swithly163444(None) 
laithly1335652laithly
sixthly2042872sixthly
smithy14508272smith_y
soothly13186922soothly
stithy12398212stith_y
swiftly1633732swiftly
swirly12439252swi_rly
swishy15365842swish_y
swith115917402swith__
swithe124010682swith_e
swither133710992swither
withy144813762_with_y
apishly1535663apishly
blithely16104033blithely
brittly12165973brittly
deathly14336863deathly
earthly13387383earthly
fifthly1943093fifthly
fitly115114973_fit_ly
highly1636823_highly
lithely1356643_lithely
loathly1334713loathly
monthly1535673monthly
ninthly1344213ninthly
owlishly1743593owlishly
pithily1567033_pithily
pithy135614463_pith_y
richly1438003_richly
saintly1039343saintly
saith85826553saith__
saithe94713913saith_e
saltily10310543saltily
shiftily1744553shiftily
shily115222013shi__ly
shingly143210813shingly
shinily13268933shinily
shitty124110063shit_ty
sickly153110483s_ickly
sightly14408273s_ightly
silly84527623s_i_lly
simply133010523s_imply
singly104015853s_ingly
sith75435153s_ith__
skittle1135533skittle
slickly1635853slickly
slightly1544603slightly
slily85820033sli__ly
slimily1247713slimily
slimly11408903sli_mly
slither104112983slither
slithery14356703slithery
slitty9329163slit_ty
smith107818053smith__
smithery16325703smithery
smiths114711023smith_s
smoothly16203643smoothly
snidely1136813snidely
sniffly16265643sniffly
softly12457763soft_ly
sootily101810523sootily
spicily1438653spicily
spikily1635873spikily
spindly13257383spindly
spital83813873spital_
spitals93011593spitals
spittle937923spittle
stately10310223stately
stiffly16235173stiffly
stilly93714093sti_lly
subtly11249263subt_ly
suitably1347593suitably
swarthily1842583swarthily
swarthy16466373swarth_y
swath115920383swath__
swathe125514113swath_e
swathed144611933swathed
swather134213603swather
swathes134115513swathes
swaths125312643swath_s
sweatily1435473sweatily
sweetly1335593sweetly
swill83417373swi__ll
swills94213363swi_lls
swimmily1842713swimmily
swimmy16234353swi_mmy
swindle11389183swindle
swingby16343893swingby
swingle113510563swingle
swingy13489873swi_ngy
swinishly1843383swinishly
swinney13365973swinney
swiple11379233swi_ple
swipple1444633swipple
swirl84514143swi_rl_
swirls94010133swi_rls
swish115114823swish__
swished14418843swished
swisher13369523swisher
swishes133411373swishes
switch14458913swit_ch
switched17157133switched
switcher16177683switcher
switches16159133switches
swithers144310533swithers
swivel12369323swivel_
swivels13396773swivels
swizzle1854103swizzle
tenthly1335743tenthly
tritely1039003tritely
twiddly15233773twiddly
twinkly1733913twinkly
twirly12427083twi_rly
twitchily2052193twitchily
twitchy18393573twitchy
wetly114511713_wet_ly
whitely16346473whitely
widely133311033_widely
wifely15429423_wifely
wiggly14559683_wiggly
wildly13328123_wildly
wilily123310763_wilily
willy115321913_wi_lly
wily106428813_wi__ly
wirily123310783_wirily
wisely122711713_wisely
witchy17468593_witchy
with105730473_with__
withal1238933_withal
withe115220233_with_e
withed134416233_withed
wither124321353_wither
withes124620843_withes
within123611383_within
witney12356843_witney
wittily1336173_wittily
witty114717013_wit_ty

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271376.89019452.4
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.34224338.2
 
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.