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

267 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
deported124970(None) 
dehorted1357301dehorted
departed1238821departed
deportee11510351deportee
deporter1169391deporter
reported11312701reported
decocted1437682decocted
decorated13312202decorated
deforced15247372deforced
deformed15248262deformed
dehorned1345682dehorned
demoted114313542demo_ted
denoted93512762deno_ted
departee1139722departee
depermed1436452depermed
depicted1437742depicted
depleted12258722depleted
deplored1237232deplor_ed
deponed113712872depo_ned
deport94922392deport__
deportees1256642deportees
deporters1277792deporters
deports105012882deport_s
deposed113412022depo_sed
deposited1346772deposited
depurated1338182depurated
deputed114610172dep_uted
deserted101012202deserted
desorbed1236442desorbed
devoted124111092devo_ted
dewormed15236222dewormed
disported13310302disported
exported1837132exported
imported13308692imported
ported94223242__ported
reporter10411422reporter
repotted1139282repotted
resorted9313492resorted
retorted9312332retorted
sported104015432_sported
aborted10310423_aborted
assorted956603assorted
bedotted1234983bedotted
besotted1135843besotted
bewormed16235443bewormed
biparted1335133biparted
cavorted1435693cavorted
comported16319533comported
darted84620923d__arted
deaerated11311113deaerated
deaired9411533deair_ed
dealated103213603dealated
debarked16175823debarked
debarred12165633debarred
debated113916083de_bated
debited113311623de_bited
deboned113411633debo_ned
debuted11379333de_buted
decanted122310493decanted
decerned1237263decerned
decoded123212383deco_ded
decorate11315193decorate_
decorates12314743decorates
decoyed14358333deco_yed
decreed112710253de_creed
decried112612853de_cried
decurved1534843decurved
deducted1356243deducted
defatted1335673defatted
defeated132812163defeated
defected15289973defected
deferred13106363deferred
deflated133412303deflated
defoamed15356243defoamed
defogged1533783defogged
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deforested1543843deforested
deformer14247943deformer
defrosted1444253defrosted
degermed1335453degermed
degreed10258883de_greed
degusted1135733degusted
dehorner1235523dehorner
dehort104618103dehort__
dehorts11379773dehort_s
dejected19307593dejected
delated93722873de_lated
deleted93314913de_leted
delisted10310563delisted
deloused1036973deloused
demarked16187223demarked
demasted1238763demasted
demented12311273demented
demerged13157603demerged
demerited1339073demerited
demitted12288773demitted
demobbed1643203demobbed
demoded123611123demo_ded
demoed103713443demo__ed
demote94817803demo_te_
demotes104717673demo_tes
demounted1344903demounted
demurred1234933demurred
denote74118043deno_te_
denotes83817003deno_tes
dentated10411703dentated
dented84120513de__nted
deorbited1343983de_orbited
depainted1375843depainted
depart94720563depart__
departees1265723departees
departs104310683depart_s
depended1337983depended
depeopled1543223depeopled
depicter1356853depicter
depilated1339653depilated
deplaned1238663deplaned
deplete103010423deplete_
depleter11298863depleter
depletes112810643depletes
deplore1039483deplor_e_
deplorer1136343deplor_er
deplores1139533deplor_es
deployed1535913deployed
deplumed1434083deplumed
depone93616553depo_ne_
depones103717093depo_nes
deporting1369593deporting
deportment1546773deportment
depose94215763depo_se_
deposer104011843depo_ser
deposes103117213depo_ses
depot85727923depo_t__
depots94716343depo_t_s
depraved1535543depraved
deprived1546463deprived
depurate1139983depurate_
depurates1239823depurates
depute94512303dep_ute_
deputes104911783dep_utes
derated93623503de_rated
deratted1048403deratted
derogated1238673derogated
desalted1038313desalted
descried1248073descried
deserter91211603deserter
deserved13108133deserved
desired9311983desir_ed
desisted1039783desisted
desolated1139653desolated
despited1248323despited
despoiled1344653despoiled
desponded1445323desponded
detected12289733detected
deterged11127923deterged
deterred10137803deterred
detested10279623detested
detonated1138213detonated
detoured1036513detoured
detoxed1636103deto_xed
devested13239133devested
deviated13311043deviated
devoiced15276063devoiced
devolved16325513devolved
devote104513783devo_te_
devotee113811823devo_tee
devotes113713753devo_tes
devoured1335723devoured
devouter1235513devouter
dewooled1333833dewooled
dewormer14256323dewormer
disparted1338853disparted
distorted1139373distorted
diverted13199583diverted
divorced1544313divorced
doated84118183d__oated
doited85016633d__oited
doted75227073d__o_ted
dotted84717523d__otted
emoted94614923_emo_ted
epoxied1734813_epoxied
epoxyed2032293_epoxyed
escorted1136703escorted
everted112711853_everted
exerted152210053_exerted
exhorted1935013exhorted
experted1838053experted
exporter1737363exporter
extorted1636233extorted
hearted113314023he_arted
homeported1853513homeported
imparted13248063imparted
importer12308913importer
imposted13257403imposted
intorted9310123intorted
leporid1048153lepor_id
parted94228683__parted
perorated12412463perorated
pored85234513__por_ed
porked134717623__porked
portend103411193__portend
porter84224413__porter
posted93722493__posted
potted94624013__potted
pouted94021393__pouted
presorted1239453presorted
purported1443463purported
rebooted11248463rebooted
rebored105015883rebor_ed
recoated113416783recoated
recorded122511063recorded
recorked15239853recorked
reexported2043323reexported
reforged13268703reforged
reformed14249603reformed
regorged11227333regorged
reimported1543783reimported
reparked15208923reparked
repartee10312753repartee
repasted112611533repasted
repeated113117443repeated
repented112614983repented
reperked15177793reperked
replated112817523replated
replotted1235823replotted
repolled11359623repolled
report85326023report__
reportedly1643213reportedly
reporters1139173reporters
reports94916213report_s
reposed103616273repo_sed
reposited1239133reposited
repoured1139563repoured
reprobed13228743reprobed
reproved14199473reproved
reputed104613483rep_uted
rerouted9311143rerouted
resorbed1138533resorbed
resorter8312183resorter
respotted1235953respotted
retorter8410733retorter
reverted122714713reverted
revolted12319863revolted
revoted114314153revo_ted
reworded13228103reworded
reworked16247773reworked
riposted11216933riposted
separated1237713separated
shorted113614403_shorted
snorted83813493_snorted
sorted74523713__sorted
spirted103913073_spirted
spored94821793_spor_ed
sporter93616553_sporter
spotted103713143_spotted
spouted103412263_spouted
spurted103111973_spurted
supported1444683supported
teleported1343313teleported
unparted11310823unparted
unposted1159433unposted
unpotted11108393unpotted
unreported1344073unreported
unsorted9312513unsorted
vapored1336923vapor_ed

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.420425454.8
2DLD Change Limit1461622676.65621959.4
3Display Results2672670.1102427.3
 (SQL Overall)1786912677.18624866.5
 
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.