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

300 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
percent11352059(None) 
percents122713361percents
percept133112521percept
perpent112318801perpent
precent113520251precent
aperient10715152aperient
decent94023702de_cent
descent102616292descent
ferment12315572ferment
fervent13310062fervent
gerent73223092ger_ent
parent83230422par_ent
peccant13311732peccant
pendent10314722pendent
percental1348652percental
percepts14247642percepts
perfect141010832perfect
permeant12310912permeant
perpend12259332perpend
perpents122312032perpents
pertest9317042pertest
pervert12315582pervert
portent93619642portent
precents123015032precents
precept133112512precept
present94022722present
prevent124016552prevent
recent83630852re_cent
rerent63832452rer_ent
serpent92916282serpent
tercet83624912terce_t
accent105116263_accent
acescent1248003acescent
aeriest73924053aeriest
aperients1178253aperients
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
ascent84519653_ascent
averment13311603averment
bereft114317303ber_eft
beret74946363ber_e_t
brent75734133_br_ent
cement103321663ce_ment
cent67451013___cent
cerement12315133cerement
cermet10321153cerme_t
concent114422513concent
credent10313973credent
crescent12711043crescent
current9313693current
decant93524223de_cant
deceit93018213de_ceit
dement93825143de_ment
descant104315583descant
descend11248153descend
descents112511203descents
detent73624483de_tent
docent92918683_docent
eeriest73620673eeriest
eluent6315483_eluent
emergent1149113emergent
eocene8311613_eocene
epicene1148593epicene
erect74129333_er_ect
erodent8313823_erodent
errant6618733_errant
event85924443_e_vent
except1797653_except
extent132714913_extent
ferments13311473ferments
ferret93021173ferre_t
fiercest13216143fiercest
fornent10312933fornent
forwent13310533forwent
garment10315233garment
gerents82612923ger_ents
germen9612313germen_
germens1078623germens
hereat93527413her_eat
horrent10313553horrent
incent83320723_incent
larceny1234853larceny
lenient7313843lenient
lucent8313823_lucent
margent10316693margent
mercer105214203merce_r
mercers114412773mercers
mercery14397623mercery
merces105720743merce_s
merchant1548793merchant
merest84725113mer_est
mermen10813813mermen_
mordent10313993mordent
nascent9610523nascent
nescient1048713nescient
nocent83217413_nocent
operant9317223oper_ant
opercele1244593opercele
orient6322533_orient
overlent112715293overlent
parament12415393parament
parcel103915473parce_l
parcels113712663parcels
parcener1238463parcener
parchment1846913parchment
parents93418123par_ents
parget94529393parge_t
parvenu1247023parvenu
patent84524923p_atent
patient9617073patient
payment14310703payment
peace95026083peace__
peaced115818913peace_d
peacenik1643483peacenik
peaces106324083peace_s
peacing124117073peacing
peacoat11412913peacoat
peahen113410133peahen_
peahens12307573peahens
peartest10311293peartest
peasant9314923peasant
peasen84815953peasen_
pecan91919033pe_can_
pecans101515833pe_cans
pecten102711103pecten_
pectens11189203pectens
pedant9319493pe_dant
pediment13411393pediment
peen65938083pe__en_
peens76428193pe__ens
pellet83326553pelle_t
pelmet103419243pelme_t
pence94924453pence__
pencel103812913pence_l
pencels113610053pencels
penchant1549563penchant
pendant10314853pendant
pendents1139413pendents
penitent10413503penitent
penmen10311493penmen_
pennant9312493pennant
pent66559073p___ent
pentene9313793pentene
percale11314083percale
perceive1546963perceive
percentage1553973percentage
percentile1447403percentile
perch124518833perc__h
perched154713233perched
percher143313423percher
perchers153611523perchers
perches143717953perches
perching163711633perching
percipient1655753percipient
percoid12312313percoid
percuss1137163percuss
pere66450263per_e__
perea75026443per_e_a
pereia85217983per_eia
pereon83517453per_eon
pereons92815003pereons
peres76246643per_e_s
perfecta15115203perfecta
perfecto15105743perfecto
perfects15107353perfects
perianth1348553perianth
periapt11313413periapt
peridot10514243peridot
perinea9313033perinea
perked134617683perke_d
perkiest143313243perkiest
perking143716453perking
permanent1368783permanent
permeate12311603permeate
permed115217343perme_d
perming123416083perming
permit10321683per_mit
perpends13227733perpends
perron83216623perron_
perrons93115483perrons
persalt9315413persalt
perse75429523perse__
perses85428063perse_s
persist9315853persist
person83517873person_
persona92812443persona
persons93717003persons
pert66759323per___t
perter84422283perte_r
pertinent11412273pertinent
perverts1337523perverts
pierce104010393pierce__
pierced12347593pierce_d
piercer11337773pierce_r
piercers12316723piercers
pierces113411193pierce_s
piercing1346663piercing
pigment12510733pigment
placenta1275723placenta
placet103923673place_t
ponent82821593p_onent
porcine11312843porcine
porcini1137633porcini
porcino1138113porcino
porrect1159743porrect
portend103411193portend
portents103512823portents
potent84223353p_otent
prebend12319443prebend
precast11314853precast
precede1239633precede
precedent1448873precedent
precented14310683precented
precentor1348733precentor
precepts14268883precepts
precess11310863precess
precinct1459413precinct
precut102016533prec_ut
preen75925053p_reen_
preens85020113p_reens
prefect141011073prefect
preheat12413893preheat
prelect111013833prelect
premeet11615153premeet
premen105017803premen_
prescient13411313prescient
presents103315633presents
preset84430983prese_t
prest75736353p_r_est
pretend104011013pretend
pretest9517633pretest
pretext1639663pretext
prevents133012293prevents
priest84125423p_riest
print74837463p_r_int
prudent10310433prudent
prurient1048233prurient
pschent1437413pschent
pubescent1545433pubescent
pungent10311233pungent
purest84021933pur_est
purulent1047613purulent
pyrene113210733pyr_ene
reaccent1278573reaccent
reagent8716603reagent
reascent10411973reascent
reblent9614253reblent
recant83228683re_cant
recept103319073re_cept
recreant10311283recreant
regent74127673re_gent
relent64431853re_lent
relucent1049283relucent
rent46661243__r_ent
reorient8613473reorient
repent84728873re_pent
rerents73319423rer_ents
resent63833623re_sent
reticent10313293reticent
sarcenet10413313sarcenet
sarment9318763sarment
scent75831623__scent
secant84023293se_cant
secret8325063secre_t
segment10312563segment
seicento1045043seicento
sequent16410323sequent
serene63522353ser_ene
serest64831613ser_est
sergeant9129403sergeant
serjeant1596473serjeant
serpents102410373serpents
servant10313623servant
sorbent92915233sorbent
sprent84522383spr_ent
terce75721843terce__
tercel83612993terce_l
tercelet1049883tercelet
tercels94110363tercels
terces83921413terce_s
tercets93512443tercets
terpene92310853terpene
terrene72411033terrene
terret63425623terre_t
tersest71713993tersest
torment9316173torment
torrent7313413torrent
trecento1066213trecento
turgent8712393turgent
unrent63219783unr_ent
urgent73816043_urgent
varment12313243varment
verbena1235373verbena
verdant11313293verdant
veriest103719133veriest
versant10313833versant
verset94327323verse_t
vervet124619063verve_t
wergelt1138583wergelt

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273008.17316398.8
3Display Results3003000.1062830.2
 (SQL Overall)1786913008.43521184.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.