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

143 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
assorted95660(None) 
asserted957901asserted
assorter866671assorter
aborted10310422a_borted
absorbed1344262absorbed
adsorbed1243442adsorbed
assented957512assented
asserter877572asserter
assisted936232assisted
assoiled935012assoiled
assort64916382assort__
assorters965732assorters
assorts73310152assort_s
assured858372assur_ed
escorted1136702escorted
missorted1247032missorted
reassorted1144362reassorted
resorted9313492resorted
shorted113614402_shorted
snorted83813492_snorted
sorted74523712__sorted
sported104015432_sported
unsorted9312512unsorted
abhorred1443493abhorred
aborter939933a_borter
absented1156613absented
absolved1443133absolved
absorber1254313absorber
accorded14155343accorded
accosted1345503accosted
acorned10238263a_corned
adopted1136253a_dopted
adored84714243a_dor_ed
adorned9256893a_dorned
adsorber1143503adsorber
adverted1336103adverted
afforded1643433afforded
airted74214503a__irted
alerted82512223a_lerted
allotted986873allotted
ansated84214003ans_ated
arbored103811603arbor_ed
armored102610473armor_ed
ascared10399523ascar_ed
ashore9414613ashor_e_
asperated1239313asperated
aspersed11428293aspersed
aspirated1247703aspirated
aspired1068173aspir_ed
assailed945323assailed
assaulted1042583assaulted
assayed1135593ass_ayed
assenter867703assenter
assert64922583assert__
assertedly1463043assertedly
asserters956393asserters
assertor865723assertor
asserts74311793assert_s
assessed945023assessed
assigned1044633assigned
assister836753assister
associated13114703associated
assorting1037303assorting
assortment1254693assortment
assuaged1044383assuaged
assumed1065293ass_umed
assure6610773assur_e_
assureds984493assur_eds
assurer767793assur_er
assures7611403assur_es
asswaged1343333asswaged
astonied978983astonied
attorned955353attorned
ausformed1542323ausformed
averted112211613a_verted
azoted16388593a_zo_ted
basseted1136743bass_eted
bassetted1244693bassetted
besotted1135843besotted
cavorted1435693cavorted
consorted1239773consorted
dehorted1357303dehorted
deported1249703deported
deserted101012203deserted
desorbed1236443desorbed
disported13310303disported
disserted11109813disserted
distorted1139373distorted
escoted1038183esco_ted
exhorted1935013exhorted
exported1837133exported
exserted1636213exserted
extorted1636233extorted
imported13308693imported
inserted92413053inserted
intorted9310123intorted
lassoed8408743lasso__ed
pastored1139963pastor_ed
ported94223243__ported
presorted1239453presorted
reasserted1145413reasserted
reported11312703reported
resorbed1138533resorbed
resorter8312183resorter
retorted9312333retorted
savored1158343savor_ed
scarted104816123_scarted
scooted103612283_scooted
scored94621133_scor_ed
scorned10229953_scorned
scouted104112033_scouted
shored105723653_shor_ed
shorten103511413_shorten
shorter103515503_shorter
shotted113912403_shotted
shouted113911553_shouted
skirted12388613_skirted
slotted84613883_slotted
smarted105012613_smarted
snooted84213283_snooted
snored74819543_snor_ed
snorter74412663_snorter
snouted84311343_snouted
sooted73922593__sooted
sorbed94916523__sorbed
sored66141783__sor_ed
sorned74820043__sorned
sorter64425093__sorter
sortied83314103__sortied
sotted74121403__sotted
spirted103913073_spirted
spored94821793_spor_ed
sporter93616553_sporter
spotted103713143_spotted
spouted103412263_spouted
spurted103111973_spurted
started84217323_started
stored75524213_stor_ed
storied8515163_storied
stormed1039043_stormed
stotted83511423_stotted
swotted11398713_swotted
visored1138143visor_ed

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621436.64322002.4
3Display Results1431430.0602383.3
 (SQL Overall)1786911436.85926052.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.