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

298 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
presents10331564(None) 
precents123015041precents
present94022731present_
presets94216421prese_ts
prevents133012291prevents
resents74221221_resents
copresents1446452copresents
crescents1367542crescents
percents122713372percents
perpents122312042perpents
prebends13347882prebends
precent113520262precent_
precepts14268892precepts
preens85020112pre_en_s
prefects1598132prefects
preheats1339412preheats
prelects1299722prelects
presells1058282presells
presence122213512presence
presences132113792presences
presented12311632presented
presentee11411862presentee
presentees1247922presentees
presenter11311642presenter
presenters1239862presenters
presentism1447242presentism
presentist12410092presentist
presently1449062presently
preset84430982prese_t_
presidents1347022presidents
presifts1366592presifts
presorts105311682presorts
prests84021262pres__ts
pretends11299112pretends
pretests10310012pretests
pretexts1735602pretexts
prevent124016552prevent_
prosects1239472prosects
regents83416542_regents
relents74018502_relents
repents93717622_repents
represents1246752represents
rerents73319422_rerents
reseats74319582_reseats
resects94115592_resects
resends83513712_resends
resent63833622_resent_
resets65427612_rese_ts
absents93510723_absents
acescents1345233acescents
aperients1178253aperients
argents84014853ar_gents
arpents93613083ar_pents
assents74512223_assents
besets85718803_bese_ts
brents84717273br__ents
brevets12519393breve_ts
cements112714223_cements
cerements13411453cerements
consents102715893consents
copresent1349923copresent_
credent10313973credent_
crescent12711053crescent_
cressets10309103cressets
crests85218703cres__ts
crusets93811043cruse_ts
dements103016623_dements
descents112511203_descents
deserts82513053_deserts
detents83615153_detents
dissents93411863dissents
elements10312173elements
events94814073__events
ferments13311473ferments
frequents2144443frequents
freshens14298313freshen_s
freshets14298673freshets
fresnels1135233fresnels
gerents82612923_gerents
greens75716873gre_en_s
greenth11116723gre_enth
greenths1295213gre_enths
greets75117423gre_e_ts
greisens954653greisen_s
orients7311583or_ients
paesanos10296703paesanos
paesans93312693paesan_s
paraments13511553paraments
parents93418123p_arents
pareses94718883parese__s
patents94815203p_atents
patients1088763patients
pavements1647003pavements
payments1536943payments
peasants1038263peasants
pedants10310113p_edants
peens76428193p_e_en_s
pendents1139413pendents
percent113520603percent_
percepts14247643percepts
perfects15107353perfects
perpends13227753perpends
perpent112318813perpent_
persalts1038193persalts
perses85428063perse__s
persists1049183persists
personas102511883personas
persons93717013person_s
perverts1337533perverts
peseta8310573p_ese_ta
pesetas938753p_esetas
pesewas1236223p_esewas
pests75933273p_es__ts
pheasants1443723pheasants
pigments1337343pigments
pissants1097363pissants
portents103512823portents
possets94212773posse_ts
praefects1642873praefects
praelects1354353praelects
prases84429023prase__s
preacts113211363pre_acts
prebend12319443preben_d
prebinds13357733prebinds
precasts1239453precasts
precedents1545723precedents
precedes13310713precedes
precented14310693precented
precentor1348733precentor
precentors1488343precentors
precept133112513precept_
precess11310863prece_ss
precincts1544993precincts
precuts111710473pre_cuts
predeath1447003predeath
predeaths1544743predeaths
predicts1339613predicts
preedits1168763preedits
preelects1356083preelects
preempts1444543preempts
preen75925053pre_en__
preenacts1345843pre_enacts
preened103214993pre_ened
preener93114833pre_ener
preeners102712813pre_eners
preerects1345413preerects
prees75937173pre_e__s
prefect141011073prefect_
prefers123713333prefe_rs
prefunds1454693prefunds
preheat12413893preheat_
preinserts1243973preinserts
prelect111013833prelect_
premeds12389593preme_ds
premeet11615153premeet_
premen105017803premen__
prepense12238943prepense
preprints1347473preprints
prerenal1049083prerenal
presages11312203presages
presales10315263presales
prescient13411323prescient_
prescinds1444953prescinds
prese75228383prese___
preselects1464363preselects
presell939303prese_ll
presenting131013023presenting
presentisms1555213presentisms
presentness1345663presentness
preserve13108803preserve
preserves14109073preserves
presettle1145943presettle
presettles1245023presettles
preships1539313preships
preshows16267023preshows
president12410993president_
presides11414913presides
presift12312223presift_
presoaks1436603presoaks
presong1039843preson_g
presort95219543presort_
press75425953pres___s
pressers103215023pressers
presses93523153pres_ses
pressings12269023pressings
pressors103212693pressors
prest75736353pres__t_
presters103419003presters
presto84216203pres__to
prestos93716083pres_tos
presumes1239843presumes
preteens1038123preteens
pretells1047333pretells
pretence122312123pretence
pretences132312613pretences
pretend104011013preten_d
pretense10199823pretense
pretenses112210593pretenses
preterits11410963preterits
preterms1237223preterms
pretest9517633pretest_
pretext1639663pretext_
pretreats1146933pretreats
prevalents1594973prevalents
prevented1539003prevented
preventer1438593preventer
preventers1547393preventers
preverbs15295303preverbs
prexes154915953prexe__s
preyers124412363preye_rs
prezes173614693preze__s
priests93810863pr_iests
prints84320103pr__ints
priseres10310823priseres
prises84133173prise__s
prisons9313223prison_s
privets122910053prive_ts
projects1936413projects
projets1639163proje_ts
propends13249173propends
propenes122816513propenes
prosect11313393prosect_
prosers94219643prose_rs
proses84733473prose__s
prospects1545103prospects
protects1239743protects
protends113010353protends
protests10310493protests
prudent10310433prudent_
pschents1544113pschents
reagents959623_reagents
reascents1177403_reascents
recants93217093_recants
recent83630853_recent_
recepts113010263_recepts
reests64618893_re_ests
refects124012743_refects
regent74127673_regent_
reheats104513523_reheats
rejects163910693_rejects
relends84013253_relends
relent64431853_relent_
relets64025673_rele_ts
remeets93712413_remeets
remelts93511493_remelts
remends105013033_remends
remints95117293_remints
renests74014213_renests
rennets75212633_rennets
rents55935183_r__ents
repeats94316053_repeats
repent84728873_repent_
represent11410073represent_
rerent63832453_rerent_
reseals73917663_reseals
reseat64131493_reseat_
reseaus74012153_reseaus
resect84424703_resect_
resedas839123_resedas
reseeds84012333_reseeds
reseeks11348623_reseeks
resees63827483_rese_es
resells73313203_resells
resend75016773_resen_d
resented92716963_resented
reset55051863_rese_t_
resews94814173_rese_ws
residents1038423_residents
resifts10378703_resifts
resins64528773_resin_s
resists74414923_resists
resits64725563_res_its
resmelts1046143_resmelts
resorts74817193_resorts
respects1247703_respects
respots92912763_respots
rests54935873_res__ts
results739833_results
retenes76324623_retenes
retests73813853_retests
retints74717013_retints
reverts104715043_reverts
revests104413733_revests
revets94022173_reve_ts
rewets94617213_rewe_ts
rodents8611543_rodents
rosets65819953_rose_ts
serpents102410373serpents
trecento1066213trecento
trecentos1155873trecentos
treens65317873tre_en_s
trevets10499973treve_ts
tridents938583tridents
trisects1035983trisects
versants1137783versants
versets103913103verse_ts
wisents10249063_wisents
wrests95313083wres__ts

Search took 10 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.920194229.3
2DLD Change Limit1461622988.08018089.4
3Display Results2982980.1232422.8
 (SQL Overall)1786912989.12319586.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.