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

139 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
swiftly163373(None) 
saintly1039342saintly
shiftily1744552shiftily
shifty15409262shift_y
sniffly16265642sniffly
softly12457762s_oftly
stiffly16235172stiffly
sweetly1335592sweetly
swift116818052swift__
swifter13318052swifter
swiftlet1444792swiftlet
swifts12408172swift_s
swirly12439252swi_rly
swithly1634442swithly
wifely15429422_wifely
wifty144212092_wift_y
bristly12178063bristly
brittly12165973brittly
daftly1335443_daftly
deftly1336533_deftly
drifty13418223drift_y
faintly1337083faintly
fifthly1943093_fifthly
fifty145211423_fift_y
fitly115114973_fi_tly
gristly11187333gristly
jointly1735483jointly
moistly1236613moistly
niftily1335753_niftily
nifty115211633_nift_y
quietly1945893quietly
rifely123710033_rifely
safely12249393s_afely
sawfly1535133sawf_ly
scantly12419553scantly
shift114225143shift__
shifted14359983shifted
shifter132911083shifter
shifts124412943shift_s
shily115222013shi__ly
shingly143210813shingly
shinily13268933shinily
shirty124312563shirt_y
shitty124110063shi_tty
shortly13387573shortly
sickly153110483s_ickly
sift710740663s_ift__
sifted104313673s_ifted
sifter94516233s_ifter
sifts84918923s_ift_s
sightly14408273sightly
silly84527623s_i_lly
silty84721633s_ilt_y
simply133010523s_imply
singly104015853s_ingly
sixthly2042873s_ixthly
sixty154912733s_ixt_y
skiffle17225203skiffle
skittle1135533skittle
slantly10399323slantly
slickly1635853slickly
slightly1544603slightly
slily85820033sli__ly
slimily1247713slimily
slimly11408903sli_mly
slitty9329163sli_tty
smartly12497433smartly
smithy14508273smi_thy
snidely1136813snidely
sniffily17154033sniffily
sniffle13287653sniffle
sniffy15337193snif_fy
snifter10349623snifter
snuffly16305203snuffly
softy115414483s_oft_y
spicily1438653spicily
spiffily19153483spiffily
spiffy17326223spif_fy
spikily1635873spikily
spindly13257383spindly
spittle937923spittle
squatly1946433squatly
stifle93611903stif_le
stilly93714093sti_lly
stithy12398213sti_thy
stoutly1035833stoutly
strictly1345813strictly
subtly11249263s_ubtly
swarthy16466373swarthy
swarty125812383swart_y
sweatily1435473sweatily
sweaty123710053sweat_y
sweltry1333413sweltry
swifters14277483swifters
swiftest1434353swiftest
swiftlets1542723swiftlets
swill83417373swi__ll
swills94213363swi_lls
swimmily1842713swimmily
swimmy16234353swi_mmy
swindle11389183swindle
swingby16343893swingby
swingle113510563swingle
swingy13489873swi_ngy
swinney13365973swinney
swiple11379233swi_ple
swipple1444633swipple
swirl84514143swi_rl_
swirls94010133swi_rls
swishy15365843swi_shy
switch14458913swi_tch
swith115917403swi_t_h
swithe124010683swi_the
swivel12369323swivel_
swivels13396773swivels
swizzle1854103swizzle
thistly1395963thistly
twiddly15233773twiddly
twinkly1733913twinkly
twirly12427083twi_rly
twisty12426863twist_y
unfitly1335573unfitly
unwifely1743603unwifely
waffly18305433_waffly
wetly114511713_w_etly
widely133311033_widely
wifey144913673_wif_ey
wiggly14559683_wiggly
wildly13328123_wildly
wilily123310763_wilily
willy115321913_wi_lly
wily106428813_wi__ly
wintle94014603_wintle
wintry12498923_wintry
wirily123310783_wirily
wisely122711713_wisely
withy144813763_wi_thy
wittily1336173_wittily
witty114717013_wi_tty

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271396.12321889.1
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.57627173.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.