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

122 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
stingily123679(None) 
stringily1346001stringily
dingily1238102_dingily
shingly143210812shing_ly
shinily13268932shin_ily
singly104015852s_ing_ly
slangily1235382slangily
slinkily1534852slinkily
spongily1444902spongily
springily1545582springily
stagily1139052st_agily
stickily1736082stickily
stingier9279122stingier
stinging103213452stinging
stingingly1544092stingingly
stingray1243582stingray
stingy105213202sting__y
stodgily1343902stodgily
stonily1049432ston_ily
tingly103815982_ting_ly
tinily94014432_tin_ily
tinnily1047362_tinnily
atingle848253ating_le
bitingly1437393biting_ly
daintily1245523daintily
dotingly1337343doting_ly
flintily1434893flintily
gingely12378213_gingely
gingili9306033_gingili
jestingly2045953jesting_ly
jingly174111933_jing_ly
kingly143511303_king_ly
kinkily1335223_kinkily
lastingly1337243lasting_ly
lyingly14115263lying_ly
mangily1339753_mangily
rainily10310433rain_ily
saintly1039343sain_tly
savingly1537313saving_ly
scantily1337583scantily
shaggily1643773shaggily
shiftily1744553shiftily
shingle117711283shing_le
sigil63515503s_i_gil_
sigils73912363s_i_gils
signify1444853s_ignify
silkily14236963s_ilkily
sillily10209783s_illily
singing93221423s_inging
single74520603s_ing_le
skimpily1963053skimpily
slimily1247713sli_mily
slinging103312863slinging
slippily1544193slippily
smirkily1753333smirkily
smudgily1543123smudgily
sniffily17154033sniffily
snippily1543573snippily
soggily1235953s_oggily
spangly1336473spang_ly
spicily1438653spi_cily
spiffily19153483spiffily
spikily1635873spi_kily
spinally1338023spinally
spindly13257383spin_dly
spunkily1733773spunkily
stalkily1534823stalkily
stanchly1644443stanchly
stanging104013653stanging
staringly1337973staring_ly
steadily1236213steadily
steamily1335803steamily
stencil946893stencil_
stencils1046403stencils
stiffly16235173sti_ffly
stilly93714093sti__lly
sting65330243sting___
stinger84314683sting_er
stingers94012743stingers
stingiest10209773stingiest
stingo74212163sting__o
stingos8459453sting_os
stingrays1342713stingrays
stings76220183sting__s
stinkier12278543stinkier
stinking133113543stinking
stinkingly1843843stinkingly
stinky134611073stin__ky
stinting93415743stinting
stockily1735443stockily
stonefly1443473stonefly
stormily1345243stormily
straggly13355563straggly
strangely1345413strangely
strigil837263strigil_
strigils946853strigils
stringier1036713stringier
stringing1139753stringing
stringy114111073string__y
strongly1245953strong_ly
stubbily1564243stubbily
stuffily17124163stuffily
sturdily1245083sturdily
sunnily1037833s_unnily
swankily1833833swankily
swimmily1842713swimmily
swingby16343893swing_by
swingier12267003swingier
swinging133411113swinging
swingingly1843343swingingly
swingle113510563swing_le
swingy13489873swing__y
tangibly1444673_tangibly
tangly104413933_tang_ly
tidily102811393_ti_dily
tinging93619463_tinging
tingle74319073_ting_le
tinkly134811153_tin_kly
tipsily1236043_tipsily
vyingly1794153vying_ly
wastingly1636373wasting_ly
windily1437943_windily

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.406440125.6
2DLD Change Limit1461621227.29620033.2
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.74823062.9
 
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.