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

177 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
escorted113670(None) 
escoted1038181esco_ted
assorted956602assorted
encored10412102encor_ed
escarped1355162escarped
escort84616482escort__
escorts9418402escort_s
escrowed1434652escrowed
exhorted1935012exhorted
exported1837132exported
extorted1636232extorted
rescored114513102rescor_ed
resorted9313492res_orted
scarted104816122_scarted
scooted103612282_scooted
scored94621132_scor_ed
scorned10229952_scorned
scouted104112032_scouted
shorted113614402_shorted
snorted83813492_snorted
sorted74523712_s_orted
sported104015432_sported
aborted10310423_aborted
accorded14155363accorded
accosted1345513accosted
acorned10238283_acorned
ascared10399523ascar_ed
asserted957903asserted
assorter866673assorter
bescorched2042323bescorched
bescoured1444333bescoured
beshouted1544073beshouted
besotted1135843bes_otted
carted98631443__carted
cavorted1435693cavorted
coated94927043__coated
corded105923353__corded
cored85044223__cor_ed
corked135020783__corked
corned95224523__corned
cortex15311473__cortex
costed95623113__costed
coted85033853__co_ted
courted103514923__courted
decocted1437683decocted
decorated13312203decorated
dehorted1357303dehorted
deported1249703deported
descanted1336673descanted
descried1248073desc_ried
deserted101012203des_erted
desorbed1236443des_orbed
discorded1438133discorded
disported13310303disported
distorted1139373distorted
ecarte84313503e_carte_
ecartes94212563e_cartes
emoted94614923e_mo_ted
encoded1139033enco_ded
encore8314773encor_e_
encores9315213encor_es
encysted1444293encysted
endorsed1057193endorsed
enforced14216743enforced
engorged1134553engorged
enrooted977423enrooted
ensconced1443343ensconced
escalated1247303escalated
escaped12388853esc_aped
escheated1546273escheated
eschewed1743443eschewed
escorting1237713escorting
escot75320083esco_t__
escots84211743esco_t_s
espoused1134853espoused
estated83715573es_tated
estopped1334993estopped
euchred13106163euchr_ed
everted112711853e_verted
excepted2055233excepted
excerpted2153873excerpted
excited1737853exc_ited
excoriated2045323excoriated
excreted1846153excreted
exerted152210053e_xerted
exhorter1845353exhorter
experted1838053experted
exporter1737363exporter
exserted1636213exserted
extorter1546513extorter
imported13308693imported
intorted9310123intorted
missorted1247033missorted
neocortex1851593neocortex
picoted1239213pico_ted
ported94223243__ported
prescored14409403prescor_ed
presorted1239453pres_orted
reassorted1144363reassorted
recoated113416783recoated
recorded122511063recorded
recorked15239853recorked
reported11312703reported
rescore95616203rescor_e_
rescores105415693rescor_es
resorbed1138533res_orbed
resorter8312183res_orter
respotted1235953respotted
restarted10410053restarted
restored96417193restor_ed
retorted9312333retorted
scanted104114393_scanted
scared95227293_scar_ed
scarfed134711183_scarfed
scarped124314403_scarped
scarred104512633_scarred
scatted103512773_scatted
scented102811883_scented
scoffed16266183_scoffed
scolded11358863_scolded
sconced12359173_sconced
scooped124611743_scooped
scooter93312873_scooter
scoped115116653_sco_ped
scorched16187203_scorched
score75526743_scor_e_
scorer84818263_scor_er
scores84725923_scor_es
scorner9259763_scorner
scoter83815483_sco_ter
scoured103811153_scoured
scourged1234573_scourged
scouter93313323_scouter
scowed124413833_sco_wed
scowled13398193_scowled
screed95718933_sc_reed
scried95817303_sc_ried
secerned1136103secerned
seconded1236353seconded
secreted1138633secreted
sectored1138073sector_ed
secured1059723secur_ed
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_s_ooted
sorbed94916523_s_orbed
sored66141783_s_or_ed
sorned74820043_s_orned
sorter64425093_s_orter
sortied83314103_s_ortied
sotted74121403_s_otted
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
uncarted11312053uncarted
uncoated11314963uncoated
uncorked152210403uncorked
unsorted9312513unsorted

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 Limit1461621777.31019994.8
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.77922970.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.