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

95 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
statedly124583(None) 
stately10310221state_ly
datedly1236022_datedly
elatedly1244792elatedly
heatedly1546052heatedly
mattedly1443882mattedly
sottedly1244302sottedly
staidly1136682sta_idly
stalely1039212stale_ly
stated75427832stated__
stiltedly1372752stiltedly
abasedly1443343abasedly
agedly1136463__agedly
agitatedly1552123agitatedly
amazedly2342843amazedly
ashamedly1842273ashamedly
astutely1153643astute_ly
belatedly1543523belatedly
biasedly1443953biasedly
dazedly2134063_dazedly
estated83715573estated__
exaltedly2042333exaltedly
fadedly1535453_fadedly
giftedly1642933giftedly
hastately1543603hastate_ly
huntedly1543583huntedly
irately1047683irate_ly
jadedly1934013_jadedly
lately93413843_late_ly
latterly1136063latterly
mazedly2234433_mazedly
mutedly1345753_mutedly
nakedly1534403_nakedly
notedly1136883_notedly
outdatedly1552143outdatedly
ovately1334433ovate_ly
pettedly1443893pettedly
relatedly1344183relatedly
sacredly1444473sacredly
sadly94519123s_a__dly
safely12249393s_afe_ly
sagely102811383s_age_ly
sanely93114613s_ane_ly
sated66238533s_ated__
seated75131063seated__
sedately1245223sedate_ly
shapely1536893shape_ly
sisterly1146333sisterly
skated114414883skated__
slated75028313slated__
slatey95417063slate__y
sparely123410673spare_ly
stably113314123sta__bly
staddle9288093sta_ddle
staged84521563staged__
stagey105915583stage__y
stagily1139053sta_gily
staked114621943staked__
staled74728103staled__
stalkily1534823stalkily
stanchly1644443stanchly
standby1334423sta_ndby
staned74824643staned__
stapedes11197753stapedes
stared75429873stared__
starkly14277033sta_rkly
started84217323started__
statable10310703statable
statal61613223stat_al_
state56237333state___
stateable1136903stateable
stater64427563state__r
staters73922343state_rs
states64337083state__s
staticky1743233staticky
statuary1144033statuary
statued8459893statued__
statusy10455423stat_usy
staved103918053staved__
stayed104817273stayed__
steely93612573s__teely
steeply1236293st_eeply
stolidly1243833stolidly
stonefly1443473stonefly
strategy1244363strate_gy
studiedly1441993studiedly
studly10397693s__tudly
stupidly1442633stupidly
suavely1376493suave_ly
tamely113711953_tame_ly
tattily10409993_tattily
tiredly1136803_tiredly
unitedly1245793unitedly
utterly1035443ut_terly
wontedly1544253wontedly

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 Limit146162956.87321266.1
3Display Results95950.0332878.8
 (SQL Overall)178691957.31224438.0
 
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.