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 “sorted” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
sorted7452371(None) 
ported94223241ported
shorted113614401shorted
snorted83813491snorted
sooted73922591sooted
sorbed94916521sorbed
sored66141781sor_ed
sorned74820041sorned
sorter64425091sorter
sortied83314101sortied
sotted74121401sotted
sported104015431sported
aborted10310422aborted
airted74214502airted
assorted956602assorted
boated94221972boated
bolted94617802bolted
booted94822732booted
borated104116362borated
bored85034302bor_ed
borked135117292borked
carted98631442carted
coated94927042coated
corded105923352corded
cored85044222cor_ed
corked135020782corked
corned95224522corned
cortex15311472cortex
costed95623112costed
coted85033852co_ted
courted103514922courted
darted84620922darted
doated84118182doated
doited85016632doited
doted75227072do_ted
dotted84717522dotted
escorted1136702escorted
farted105121782farted
footed104418622footed
forced126316522forced
forded115020392forded
forged115519322forged
forked145217142forked
formed125021172formed
forte86131462forte_
fortes95327182fortes
girted83912872girted
gored75227082gor_ed
gorged95016982gorged
gormed105013832gormed
hooted104422662hooted
horded115420482horded
horned105718702horned
horsed105321082horsed
hosted105020342hosted
hotted104319942hotted
jolted143510632jolted
jotted143615172jotted
lofted103811892lofted
looted74421112looted
lorded84916732lorded
lotted74222402lotted
louted74920692louted
marted94425212marted
moated94819002moated
molted94217472molted
mooted94120372mooted
normed95014542normed
noted65123842no_ted
opted84914272_opted
orated74221502_orated
orbed85516192_orbed
outed65429062_outed
parted94228682parted
pored85234512por_ed
porked134717622porked
portend103411192portend
porter84224412porter
posted93722492posted
potted94624012potted
pouted94021392pouted
resorted9313492resorted
rooted75424002rooted
rotted74524432rotted
routed75624332routed
salted74121202salted
sated66238532s_ated
sauted74119602sauted
scarted104816122scarted
scooted103612282scooted
scored94621132scor_ed
scorned10229952scorned
scouted104112032scouted
screed95718932screed
scried95817302scried
seated75131062seated
sered65737292ser_ed
serged84118772serged
served104616812served
shored105723652shor_ed
shorten103511412shorten
shorter103515502shorter
shotted113912402shotted
shouted113911552shouted
shred98125612shr_ed
shuted103913172shuted
sifted104313672sifted
silted74020012silted
sired66134282sir_ed
sited65130742s_ited
skated114414882skated
skirted12388612skirted
skited114313482skited
slated75028312slated
slotted84613882slotted
smarted105012612smarted
snooted84213282snooted
snored74819542snor_ed
snorter74412662snorter
snouted84311342snouted
soaked114717592soaked
soaped95817972soaped
soared74324292soared
sobbed113516262sobbed
socked134721502socked
sodded94113302sodded
soften9429492soften
softer94015312softer
sogged95518522sogged
soiled73822472soiled
solated83618022solated
soled65835172so_led
soloed74515742soloed
solved105312932solved
soothed113712742soothed
sopited104211062sopited
sopped114819902sopped
sorbet83924082sorbet
sord56237202sor__d
sordid83411162sordid
sore47059532sor_e_
sorel56231442sor_el
sorer56236592sor_er
sores55454282sor_es
sorites73825242sorites
sorner64720392sorner
sorrel6413552sorrel
sort46264812sort__
sorta57125412sort_a
sorters74221132sorters
sortie63621992sortie
sorties74126402sorties
sorts54536662sort_s
souled75419822souled
souped95017672souped
sourced1038452sourced
soured74921862soured
soused74822982soused
souter64225922souter
southed114313992southed
sowed94933862so_wed
spirted103913072spirted
spited94820442spited
spored94821792spor_ed
sporter93616552sporter
spotted103713142spotted
spouted103412262spouted
spurted103111972spurted
started84217322started
stated75427832stated
stored75524212stor_ed
storied8515162storied
stormed1039042stormed
stotted83511422stotted
suited74019422suited
surfed103814462surfed
surged84118882surged
swotted11398712swotted
tarted74923372tarted
toited74016752toited
tooted74620122tooted
torte55431702torte_
torten65314352torten
tortes64826052tortes
toted64929482to_ted
totted74319952totted
touted74419742touted
unsorted9312512unsorted
vortex1635922vortex
voted93919142vo_ted
warted104223232warted
wonted103213282wonted
worded114316622worded
worked145314702worked
wormed124314302wormed
worsted1138012worsted
worthed1437872worthed
wotted104115712wotted

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511982.31335690.0
3Display Results1981980.0633142.9
 (SQL Overall)1786911982.71965719.4
 
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.