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

346 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
portent9361964(None) 
portend103411191portend
portents103512821portents
potent84223351po_tent
content94326152content
fornent10312932fornent
forwent13310532forwent
horrent10313552horrent
mordent10313992mordent
orient6322532_orient
parent83230422par_ent
patent84524922p_atent
percent113520602percent
perpent112318812perpent
pertest9317042pertest
ponent82821592po_nent
porrect1159742porrect
ported94223242porte_d
portends11358962portends
porter84224412porte_r
porters93722702porters
porting103021782porting
protect11313632protect
protend104012792protend
protest9317532protest
sorbent92915242sorbent
torment9316172torment
torrent7313412torrent
torten65314352torten_
apartment1347033apartment
aperient10715153aperient
appetent1248083appetent
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
attent62818323_attent
bartend1038753bartend
boreen8314313boreen_
boreens9310403boreens
brent75734133_br_ent
chorten122811303chorten_
chortens13308793chortens
coagent10313983coagent
cogent9321003co_gent
comment1310317703comment
concent114422513concent
consent93723113consent
contend103511893contend
contents104018213contents
contest93523233contest
context163913433context
convent123919413convent
cornet84436733corne_t
coronet94227173coronet
correct11513983correct
corset85636223corse_t
cortege1098953cortege
cortex15311473corte_x
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
corvet114626933corve_t
current9313693current
curtest9713963curtest
deportment1546773deportment
detent73624483_detent
distent84120853distent
docent92918683do_cent
dormant102814373dormant
dormient1148453dormient
erodent8313823erodent
extent132714913_extent
ferment12315573ferment
fervent13310063fervent
foment113718303fo_ment
forest94926743for_est
forewent1439423forewent
forfeit1339203forfeit
forfend1435413forfend
forget106326393forge_t
forint9325023for_int
formant123416003formant
forspent1348163forspent
forte86131463forte__
fortes95327183forte_s
fortune1068303fortune
garment10315233garment
gerent73223103ger_ent
gorget87123863gorge_t
gorhen1038903gorhen_
gorhens1137183gorhens
goriest82218743goriest
gotten73410113gotten_
hornet94926433horne_t
hottest10411383hottest
important1346723important
impotent1249533impo_tent
intent63122773_intent
latent64124303_latent
loment84021473lo_ment
margent10316693margent
marten84518263marten_
martens93714953martens
molten83311813molten_
moment103319683mo_ment
mordant10312403mordant
mordents1138813mordents
moreen8313343moreen_
moreens939963moreens
morgen9312203morgen_
morgens10310463morgens
mostest9314793mostest
motet75641193mo_te_t
nocent83217413no_cent
oaten55222403_oaten_
obtect10129633_obtect
obtest81213013_obtest
octant81216553_octant
octet7324063_octe_t
often84611413_often_
oftest91212003_oftest
opulent938833opulent
orgeat7515033_orgeat
orients7311583_orients
outeat62824533_outeat
outwent10311363_outwent
parament12415393parament
parents93418123par_ents
parget94529393parge_t
partan83820563partan_
partans94418283partans
parted94228683parte_d
parting103527383parting
partlet92720363partlet
partner92811393partner
parton84720993parton_
partons94620513partons
parvenu1247023parvenu
paten74827343p_aten_
patens84820863p_atens
patents94815203p_atents
patient9617073patient
patten84418193patten_
pattens95414923pattens
payment14310703payment
peartest10311303peartest
pecten102711103pecten_
pectens11189203pectens
pendent10314723pendent
penitent10413503penitent
pent66559073p___ent
pentene9313793pentene
percents122713373percents
percept133112523percept
perfect141010833perfect
permeant12310913permeant
perpend12259353perpend
perpents122312043perpents
perter84422283perte_r
pertinent11412273pertinent
pervert12315583pervert
pigment12510733pigment
platen84518203platen_
platens94213983platens
pocket144622623pocke_t
poet65552903po__e_t
poetess938933poetess
point75338733po__int
pokiest133314913pokiest
polenta9310093po_lenta
politest10312943politest
pollen83416453pollen_
pollens93713303pollens
polyene1259363polyene
polytene1367603polytene
polyteny1665193polyteny
pontes83627853ponte_s
pontine92419053pontine
ponton83217643ponton_
pontons93315553pontons
poorest9312773poorest
poppet92717323poppe_t
porcine11312843porcine
porcini1137633porcini
porcino1138113porcino
pore66451263por_e__
pored85234513por_e_d
pores75849033por_e_s
poring94227273por_ing
porked134717623porke_d
porker124917543porke_r
porkers134314933porkers
porkiest143513713porkiest
porking143515813porking
porn65636023por__n_
porniest103214313porniest
porno75120653por__no
porns75527343por__ns
porny106020193por__ny
port66059633por___t
portage103013643portage
portal84218463port_al
portals94015563portals
portamenti1454203portamenti
portamento1463793portamento
portance12310123portance
portended1345643portended
portentous1244423portentous
portered112311543portered
portering122012303portering
portico11310143portico
portiere1038773portiere
portion9615493portion
portions10514413portions
portless10310643portless
portliest11310183portliest
portly114713403port_ly
portrait10510323portrait
portray1237483portray
portress1038323portress
ports75934593port__s
poshest12312423poshest
posset84923253posse_t
posted93722493poste_d
posteen93512623posteen
posteens10309733posteens
poster84129173poste_r
postern93615613postern
posterns102713723posterns
posters93928013posters
postheat13411243postheat
postin83521033postin_
posting105622243posting
postins93721203postins
postmen113110423postmen_
posttest10410233posttest
poteen83514263po_teen
poteens92910883poteens
potence11711363po_tence
potency1457433po_tency
potently1347403po_tently
potmen102713093potmen_
potted94624013potte_d
potteen9319673potteen
potteens10256793potteens
potter83926983potte_r
potters94024343potters
pottery123011073pottery
pottiest102815973pottiest
potting103720893potting
pouted94021393poute_d
pouter83923983poute_r
pouters94221873pouters
poutiest103016793poutiest
poutine93316823poutine
pouting103519943pouting
powter114116033powte_r
powters124015663powters
poxiest163412253poxiest
precent113520263precent
preen75925053p_reen_
preens85020113p_reens
present94022733present
prest75736353p_r_est
pretend104011013pretend
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
priest84125423p_riest
print74837463p_r_int
progeny1389463progeny
project1838453project
projet15315183proje_t
propend123311273propend
propene112716043propene
prosect11313393prosect
protea82214763prote_a
protean92412193protean
proteans102811543proteans
proteas92015123proteas
protects1239743protects
protege1059153protege
protei82615313prote_i
proteid103513673proteid
protein92414733protein
proteins102114283proteins
protends113010353protends
protests10310493protests
proteus92511593proteus
protist9320223protist
proton84318893proton_
protons93118003protons
proven114314773proven_
prowest12311533prowest
prudent10310433prudent
prurient1048233prurient
pschent1437413pschent
pungent10311233pungent
purest84021933pur_est
purtiest102414113purtiest
purulent1047613purulent
pyrene113210733pyr_ene
rent46661243__r_ent
reorient8613473reorient
rerent63832453rer_ent
rodent7519243ro_dent
rotten64115433rotten_
sarment9318763sarment
serpent92916283serpent
shorten103511413shorten_
shortens11288993shortens
shortest11310783shortest
soften9429493soften_
softens10347623softens
softest10310603softest
solvent10310833solvent
sorbents10279133sorbents
sorbet83924083sorbe_t
sorest65028003sor_est
sorted74523713sorte_d
sorter64425093sorte_r
sorters74221133sorters
sorting83221813sorting
sported104015433sporte_d
sporter93616553sporte_r
sporters103714063sporters
sportiest111711033sportiest
sporting112415463sporting
sprent84522383spr_ent
stent55634513__stent
tartest72517533tartest
tent46159863___tent
torments10310453torments
torrents838143torrents
torte55431703torte__
tortes64826053torte_s
tortoni738033tortoni
turgent8712393turgent
unrent63219783unr_ent
urgent73816043_urgent
urtext1337433_urtext
varment12313243varment
vortex1635923vorte_x
worsen95513873worsen_
worsens104610263worsens
worset96726583worse_t

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273466.58020368.8
3Display Results3463460.1232813.0
 (SQL Overall)1786913467.12325086.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.