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

225 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
portents10351282(None) 
portends11358961portends
portent93619641portent_
contents104018212contents
mordents1138812mordents
orients7311582_orients
parents93418122par_ents
patents94815202p_atents
percents122713372percents
perpents122312042perpents
portend103411192porten_d
portentous1244422portentous
porters93722702porte_rs
potent84223352po_tent_
protects1239742protects
protends113010352protends
protests10310492protests
sorbents10279132sorbents
torments10310452torments
torrents838142torrents
apartments1445703apartments
aperients1178253aperients
argents84014853_argents
arpents93613083_arpents
bartends1136793bartends
boreens9310403boreen_s
brents84717273_br_ents
chortens13308793chorten_s
coagents1138453coagents
comments142913883comments
concents122516603concents
consents102715893consents
contends112810573contends
content94326153content_
contests103413383contests
contexts17378653contexts
convents132614603convents
cornets94820573corne_ts
coronets103814363coronets
corrects1259573corrects
corsets94819803corse_ts
corteges1198823corteges
cortexes1797613cortexes
cortinas102212453cortinas
cortins92421333cortin_s
corvets124715023corve_ts
currents1038373currents
deportments1655753deportments
detents83615153_detents
docents102810803do_cents
extents142610173_extents
ferments13311473ferments
foments122912053fo_ments
forests104114953for_ests
forfeits1445803forfeits
forfends1544833forfends
forgets113813793forge_ts
forints10411833for_ints
formants13269953formants
fornent10312933fornent_
fortes95327183forte__s
fortunes1158283fortunes
forwent13310533forwent_
garments1139963garments
gerents82612923ger_ents
gorgets94711783gorge_ts
gorhens1137183gorhen_s
hornets104113553horne_ts
horrent10313553horrent_
impotents1347003impo_tents
intents72115703_intents
latents75214313_latents
loments93413473lo_ments
margents11410133margents
martens93714953marten_s
moments113113123mo_ments
mordants1137143mordants
mordent10313993mordent_
moreens939963moreen_s
morgens10310463morgen_s
mostests1036833mostests
motets84216193mo_te_ts
obtests9136233_obtests
octants9128733_octants
octets839403_octe_ts
orgeats838353_orgeats
orient6322533_orient_
outeats72215703_outeats
paraments13511553paraments
parent83230423par_ent_
pargets105215193parge_ts
partans94418283partan_s
partings113513733partings
partlets102811513partlets
partners102711133partners
partons94620513parton_s
parvenus1335653parvenus
patens84820863p_aten_s
patent84524923p_atent_
patients1088763patients
pattens95414923patten_s
payments1536943payments
pectens11189203pecten_s
pendents1139413pendents
penitents1147703penitents
pentenes10315633pentenes
percent113520603percent_
percepts14247643percepts
perfects15107353perfects
perpends13227753perpends
perpent112318813perpent_
pertest9317043pertest_
pertness10310093pertness
perverts1337533perverts
pigments1337343pigments
platens94213983platen_s
pockets154612253pocke_ts
poetess938933poete_ss
poets76024443po__e_ts
points85618533po__ints
polenta9310093po_lenta
polentas1038743po_lentas
pollens93713303pollen_s
polyenes13510063polyenes
ponent82821593po_nent_
pontes83627853ponte__s
pontons93315553ponton_s
poppets10338853poppe_ts
porcinis1246953porcinis
pores75849033por_e__s
porkers134314933porke_rs
pornos85015253por__nos
porns75527343por__n_s
porrect1159743porrect_
portages112613223portages
portals94015563port_als
portamenti1454203portamenti
portamento1463793portamento
portance12310123portance
portances1349833portances
ported94223243porte__d
portended1345643portended
porter84224413porte__r
portered112311543portered
porteress1137933porteress
porticos1238383porticos
portieres1138223portieres
porting103021783portin_g
portions10514413portions
portless10310643portless
portraits1146803portraits
portrays1345293portrays
portress1038323portress
ports75934593por___ts
possets94212773posse_ts
posteens10309733posteens
posterns102713723posterns
posters93928013poste_rs
postheats1447433postheats
postings112912303postings
postins93721203postin_s
posttests1144973posttests
poteens92910883po_teens
potence11711363po_tence
potences12710693po_tences
potency1457433po_tency
potently1347403po_tently
potteens10256793potteens
potters94024343potte_rs
pouters94221873poute_rs
poutines102415103poutines
powters124015663powte_rs
precents123015043precents
preens85020113p_reen_s
presents103315643presents
prests84021263p_r_ests
pretends11299113pretends
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
priests93810863p_riests
prints84320103p_r_ints
projects1936413projects
projets1639163proje_ts
propends13249173propends
propenes122816513propenes
prosects1239473prosects
proteans102811543proteans
proteas92015123prote_as
protect11313633protect_
proteges1149923proteges
proteids11259953proteids
proteins102114283proteins
protend104012793proten_d
protest9317533protest_
proteus92511593prote_us
protists10313363protists
protons93118003proton_s
pschents1544113pschents
pyrenes123511223pyr_enes
rents55935183__r_ents
reorients997363reorients
rerents73319423rer_ents
rodents8611543ro_dents
sarments10311963sarments
serpents102410373serpents
shortens11288993shorten_s
softens10347623soften_s
solvents1136763solvents
sorbent92915243sorbent_
sorbets93012513sorbe_ts
sorters74221133sorte_rs
sporters103714063sporte_rs
stents65019453__stents
tents56434213___tents
torment9316173torment_
torrent7313413torrent_
torten65314353torten__
tortes64826053torte__s
tortonis848743tortonis
urtexts1433143_urtexts
varments1339063varments
vortexes18114053vortexes
worsens104610263worsen_s
worsets105512843worse_ts

Search took 9 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.436409841.7
2DLD Change Limit1461622257.75018859.6
3Display Results2252250.0932419.4
 (SQL Overall)1786912258.27921583.6
 
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.