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

184 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
perpents12231203(None) 
percents122713371percents
perpends13227741perpends
perpent112318801perpent_
serpents102410371serpents
aperients1178252aperients
arpents93613082_arpents
ferments13311472ferments
gerents82612922ger_ents
parents93418122par_ents
pendents1139412pendents
percent113520602percent_
percepts14247642percepts
perfects15107352perfects
perpend12259342perpen_d
perverts1337532perverts
portents103512822portents
precents123015042precents
presents103315642presents
prevents133012292prevents
repents93717622re_pents
rerents73319422rer_ents
serpent92916282serpent_
terpenes102111562terpenes
aperient10715153aperient_
argents84014853_argents
arpens84814823_arpen_s
arpent84822093_arpent_
averments1449093averments
berets85822523ber_e_ts
brents84717273_br_ents
carpets113915333carpe_ts
cements112714223ce_ments
cerements13411453cerements
cermets1139713cerme_ts
currents1038373currents
deepens10307813deepen_s
dements103016623de_ments
depends11348993de_pends
descents112511203descents
detents83615153de_tents
eluents738703_eluents
emergents1245973emergents
erects84116183_er_ects
errants7410643_errants
events94814073_e_vents
expects1866883_expects
expends17217083_expends
experts1659063_experts
extents142610173_extents
ferment12315573ferment_
ferrets103111393ferre_ts
fervent13310063fervent_
garments1139963garments
gerent73223093ger_ent_
germens1078623germen_s
herpes115517323herpe__s
margents11410133margents
mordents1138813mordents
operants1039483oper_ants
orients7311583_orients
paraments13511553paraments
parapets1239763parape_ts
parent83230423par_ent_
pargets105215193parge_ts
parvenus1335653parvenus
patents94815203p_atents
patients1088763patients
payments1536943payments
peahens12307573peahen_s
peasants1038263peasants
pectens11189203pecten_s
pedants10310113pe_dants
pediments1448343pediments
peens76428193pe__en_s
peepers113713673peepe_rs
pellets94014783pelle_ts
pelmets11309693pelme_ts
pendants1139093pendants
pendent10314723pendent_
penitents1147703penitents
pennants1037063pennants
penpoints1344553penpoints
pentenes10315633pentenes
pepinos1137693pe_pinos
peppers103311443peppe_rs
percental1348653percental
percept133112523percept_
percipients1753663percipients
pereons92815003per_eons
peres76246643per_e__s
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
perianth1348553perianth
perianths1445473perianths
periapts1237273periapts
peridots1138323peridots
peripety1546183peripe_ty
permanents1455453permanents
permeant12310913permeant_
permeate12311613permeate
permeates13311773permeates
permits11314003per_mits
perpended1546073perpended
perplexes2044673perplexes
perps95521483perp___s
perrons93115483perron_s
persalts1038193persalts
perses85428063perse__s
persists1049183persists
personas102511883personas
persons93717013person_s
perspexes2043833perspexes
pertest9317043pertest_
pertness10310093pertness
pervert12315583pervert_
pigments1337343pigments
pigpens1235503pigpen_s
pipets105714773p_ipe_ts
poppets10338853poppe_ts
portends11358963portends
portent93619643portent_
prebends13347883prebends
precent113520263precent_
precepts14268893precepts
preens85020113p_reen_s
prefects1598133prefects
preheats1339413preheats
prelects1299723prelects
prepense12238943prepense
preprints1347473preprints
present94022733present_
presets94216423prese_ts
prests84021263p_r_ests
pretends11299113pretends
pretests10310013pretests
pretexts1735603pretexts
prevent124016553prevent_
priests93810863p_riests
prints84320103p_r_ints
propends13249173propends
propenes122816513propenes
pschents1544113pschents
puppets10317013puppe_ts
purports1265783purports
pyrenes123511223pyr_enes
reagents959623reagents
regents83416543re_gents
relents74018503re_lents
rents55935183__r_ents
reopens939373reopen_s
reorients997363reorients
repeats94316053re_peats
repent84728873re_pent_
reprints1039903reprints
rerent63832453rer_ent_
rerepeats1145263rerepeats
resents74221223re_sents
respects1247703respects
sarments10311963sarments
segments1138903segments
sequents1756993sequents
serenes73222903ser_enes
sergeants10115593sergeants
serjeants1673963serjeants
servants1137993servants
sorbents10279133sorbents
tempests1234443tempests
tercets93512443terce_ts
terpene92310853terpen_e
terpenic1247213terpenic
terrenes82212603terrenes
terrets72913583terre_ts
torments10310453torments
torrents838143torrents
varments1339063varments
verbenas1345343verbenas
versants1137783versants
versets103913103verse_ts
vervets13419753verve_ts
wergelts1253413wergelts

Search took 7 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.1561145455.1
2DLD Change Limit1461621846.50022486.5
3Display Results1841840.0632920.6
 (SQL Overall)1786911846.71926594.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.