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

80 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
sottedly124430(None) 
mattedly1443882mattedly
notedly1136882no_tedly
pettedly1443892pettedly
rottenly1144152rottenly
sotted74121402sotted__
statedly1245832statedly
wontedly1544252wontedly
bitterly1335603bitterly
botchedly2042593botchedly
cowedly1635703co_wedly
datedly1236023_datedly
doggedly1543103doggedly
dotardly1343843dotardly
dotted84717523dotted__
dottel73610893dotte_l_
dottels8327783dotte_ls
dottily1147283dott_ily
elatedly1244793elatedly
forcedly1744803forcedly
forkedly1944323forkedly
giftedly1642933giftedly
gorgedly1444003gorgedly
heatedly1546053heatedly
hotted104319943hotted__
huntedly1543583huntedly
jointedly20132723jointedly
jotted143615173jotted__
latterly1136063latterly
lotted74222403lotted__
lottery10389833lotte_ry
moltenly1344583moltenly
motherly16346093motherly
mutedly1345753_mutedly
pointedly15133673pointedly
potbelly1544213potbelly
potted94624013potted__
pottery123011073potte_ry
rotted74524433rotted__
rotundly1243433rotundly
sacredly1444473sacredly
shotted113912403shotted__
sisterly1146333sisterly
slotted84613883slotted__
snottily1145553snott_ily
soberly1236943so_berly
soddenly1343783soddenly
softly12457763soft__ly
solely93714213so_le_ly
solidly1137353so_lidly
somberly1544053somberly
someday1345883so_meday
sooted73922593sooted__
soothly13186923soot_hly
sootily101810523soot_ily
sordidly1344663sordidly
sorely94618013so_re_ly
sortably1338803sortably
sorted74523713sorted__
sottishly1543763sottishly
soundly1136683so_undly
southerly1544183southerly
sowbelly1643873sowbelly
spotted103713143spotted__
spottily1335153spott_ily
staidly1136683s_taidly
stately10310223state_ly
steely93612573s__teely
steeply1236293s_teeply
stiltedly1372753stiltedly
stolidly1243833stolidly
stonefly1443473stonefly
stotted83511423stotted__
studly10397693s__tudly
swotted11398713swotted__
totted74319953totted__
tottery10388483totte_ry
unitedly1245793unitedly
utterly1035443_utterly
wotted104115713wotted__

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 Limit146162807.26620115.9
3Display Results80800.0332424.2
 (SQL Overall)178691807.70523191.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.