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

391 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
present9402273(None) 
precent113520261precent
presents103315641presents
preset84430981prese_t
prevent124016551prevent
resent63833621_resent
copresent1349922copresent
credent10313972credent
crescent12711052crescent
percent113520602percent
perpent112318812perpent
prebend12319442prebend
precents123015042precents
precept133112512precept
preen75925052pre_en_
preens85020112pre_ens
prefect141011072prefect
preheat12413892preheat
prelect111013832prelect
premeet11615152premeet
premen105017802premen_
prescient13411322prescient
prese75228382prese__
presell939302presell
presence122213512presence
presented12311632presented
presentee11411862presentee
presenter11311642presenter
presently1449062presently
presets94216422presets
president12410992president
presift12312222presift
presong1039842presong
presort95219542presort
prest75736352pres__t
pretend104011012pretend
pretest9517632pretest
pretext1639662pretext
prevents133012292prevents
prosect11313392prosect
prudent10310432prudent
recent83630852_recent
regent74127672_regent
relent64431852_relent
repent84728872_repent
represent11410072represent
rerent63832452_rerent
reseat64131492_reseat
resect84424702_resect
resend75016772_resend
resents74221222_resents
reset55051862_rese_t
absent84016993_absent
acescent1248013acescent
aperient10715153aperient
appetent1248083appetent
ardent73022613ar_dent
argent74023663ar_gent
arisen65316793arisen_
arpent84822093ar_pent
arseno6318913ar_seno
assent65119953_assent
beset76739133_bese_t
brent75734133br__ent
brevet115717333breve_t
brisant9312683brisant
cement103321673_cement
cerement12315133cerement
clement11313773clement
consent93723113consent
copresents1446453copresents
crescents1367543crescents
cresset93319943cresset
crest74632693cres__t
cruset84425093cruse_t
decent94023703_decent
dement93825153_dement
descent102616293_descent
desert72725493_desert
detent73624483_detent
dissent84018683dissent
drest65530343dres__t
element9317803element
erodent8313823erodent
event85924443__event
ferment12315573ferment
fervent13310063fervent
forewent1439423forewent
freest95318283fre_est
frequent2046423frequent
freshen133010883freshen_
freshens14298313freshens
freshest143010583freshest
freshet133416643freshet
fresnel1035893fresnel
gerent73223103_gerent
green65522143gre_en_
greens75716873gre_ens
greenth11116723gre_enth
greeny104811453gre_eny
greet65835323gre_e_t
greisen856503greisen_
greisens954653greisens
greyest11348343greyest
missent94318713missent
orient6322533or_ient
paesan85114093paesan_
paesani9348683paesani
paesano9338793paesano
paesans93312693paesans
parament12415393parament
parent83230423p_arent
pareses94718883parese_s
passant9813943passant
patent84524923p_atent
patient9617073patient
pavement1549443pavement
payment14310703payment
peasant9314923peasant
peasen84815963peasen_
pedant9319493p_edant
peen65938083p_e_en_
peens76428193p_e_ens
pendent10314723pendent
pent66559073p___ent
percents122713373percents
percept133112523percept
perfect141010833perfect
permeant12310913permeant
perpend12259353perpend
perpents122312043perpents
persalt9315413persalt
perse75429523perse__
perses85428063perse_s
persist9315853persist
person83517873person_
persona92812453persona
persons93717013persons
pertest9317043pertest
pervert12315583pervert
peseta8310573p_eseta
pesewa1135543p_esewa
pest65555293p_es__t
pheasant1347083pheasant
pigment12510733pigment
pissant91012503pissant
pleasant1048323pleasant
ponent82821593p_onent
portent93619643portent
posset84923253posse_t
potent84223353p_otent
praefect1544773praefect
praelect1247533praelect
prase76128753prase__
prases84429023prase_s
preact103220393pre_act
prebends13347883prebends
prebind123810643prebind
precast11314853precast
precede1239653precede
precedent1448873precedent
precented14310693precented
precentor1348733precentor
precepts14268893precepts
precess11310863precess
precinct1459423precinct
precisest13259003precisest
precut102016533pre_cut
predeath1447003predeath
predict12315323predict
pree67044733pre_e__
preed85128123pre_e_d
preedit10512463preedit
preeing103817673preeing
preelect1249643preelect
preempt1337723preempt
preenact12410183pre_enact
preened103214993pre_ened
preener93114833pre_ener
preerect1259273preerect
prees75937173pre_e_s
prefects1598133prefects
prefer113813203prefe_r
prefers123713333prefers
prefund1335733prefund
pregnant1149883pregnant
preheats1339413preheats
preinsert1148573preinsert
prelects1299723prelects
preman104117453preman_
premeal11310523premeal
premed114617763preme_d
premeds12389593premeds
premixt183510663premixt
premolt11312073premolt
premune1138933premune
prepense12238943prepense
preplant12712913preplant
prepotent1349573prepotent
preprint12314183preprint
prerenal1049083prerenal
preriot9316413preriot
presa74319043pres__a
presage10312293presage
presale9416353presale
prescind1338393prescind
preselect1346983preselect
presells1058283presells
presences132113793presences
presentees1247923presentees
presenters1239863presenters
presenting131013023presenting
presentism1447243presentism
presentist12410093presentist
preserve13108803preserve
presettle1145943presettle
preship1439793preship
preshow15237413preshow
preside10715613preside
presidents1347023presidents
presifts1366593presifts
presleep1244493presleep
presoak1348453presoak
presold1059603presold
presorts105311683presorts
presplit1247753presplit
press75425953pres__s
pressed103317313pressed
presser93717623presser
pressers103215023pressers
presses93523153presses
pressing112516443pressing
pressmen1238833pressmen_
pressor93512883pressor
prester93519623prester
presterna1145263presterna
presters103419003presters
presto84216203pres_to
prestos93716083prestos
prests84021263pres_ts
presume11310303presume
preteen939873preteen
preteens1038123preteens
pretell938243pretell
pretence122312123pretence
pretends11299113pretends
pretense10199823pretense
preterit10315843preterit
preterm11310163preterm
pretests10310013pretests
pretexts1735603pretexts
pretreat10311923pretreat
prevalent14128063prevalent
prevented1539003prevented
preventer1438593preventer
preverb14317063preverb
prexes154915953prexe_s
preyed125313203preye_d
preyer114413733preye_r
preyers124412363preyers
preying133114553preying
prezes173614693preze_s
priest84125423pr_iest
print74837463pr__int
prise74632613prise__
prised94322203prise_d
prisere9310943prisere
prises84133173prise_s
prising103321453prising
prison8514023prison_
prisons9313223prisons
privet113821343prive_t
progeny1389463progeny
project1838453project
projet15315183proje_t
propend123311273propend
propene112716043propene
prose75835123prose__
prosects1239473prosects
prosed94921093prose_d
proser84223463prose_r
prosers94219643prosers
proses84733473prose_s
prosiest10416523prosiest
prosing103319383prosing
prosit85124593pros_it
prospect1447893prospect
prost75434103pros__t
protect11313633protect
protend104012793protend
protest9317533protest
proven114314773proven_
prowest12311533prowest
prurient1048233prurient
pschent1437413pschent
pubescent1545443pubescent
pulsant9310563pulsant
pungent10311233pungent
purest84021933pures__t
purulent1047613purulent
putrescent1465213putrescent
reagent8716603_reagent
reascent10411983_reascent
reblent9614253_reblent
recant83228683_recant
recept103319073_recept
redeny102712733_redeny
reest54938093_re_est
refect114319333_refect
refelt94521423_refelt
regents83416543_regents
reheat94423943_reheat
reject154116283_reject
relend76116453_relend
relents74018503_relents
relet54749823_rele_t
remeet86325473_remeet
remelt85123123_remelt
remend95216553_remend
remet74843723_reme_t
remint85329983_remint
renest64529713_renest
rennet64624853_rennet
rent46661243_r__ent
repeat85127213_repeat
repents93717623_repents
represents1246753represents
rerents73319423_rerents
resat55139683_res_at
reseal64819643_reseal
reseats74319583_reseats
reseau64216213_reseau
resects94115593_resects
reseda739703_reseda
resee54336333_rese_e
reseed74823293_reseed
reseek103813133_reseek
reseen64318413_reseen
resees63827483_resees
resell64215203_resell
resends83513713_resends
resented92716963_resented
resets65427613_resets
resew84519503_rese_w
resewn9459813_resewn
resews94814173_resews
reshot93519633_reshot
resident9313753_resident
resift94017723_resift
resin54131053_resin_
resins64528773_resins
resiny94617363_resiny
resist64524533_resist
resit54241043_res_it
resmelt9411773_resmelt
resort65728623_resort
respect11412033_respect
respelt9312143_respelt
respot83117633_respot
rest46459843_res__t
result6318223_result
retene69224273_retene
retest64028453_retest
retint65633443_retint
revert93529113_revert
revest94623603_revest
revet84938843_reve_t
rewet85135153_rewe_t
rident7520193_rident
risen54621883_risen_
rodent7519243_rodent
roset55945243_rose_t
sent46963013___sent
serpent92916283serpent
sprent84522383spr__ent
tersest71713993tersest
trecento1066213trecento
treen55622753tre_en_
treens65317873tre_ens
trevet94818913treve_t
trident8314193trident
trisect939733trisect
unsent63820963_unsent
uprisen9227353uprisen_
upsent83314063_upsent
urgent73816043ur_gent
versant10313833versant
verset94327323verse_t
virescent1445883virescent
wisent93516343_wisent
wrest84925433wres__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.390458182.1
2DLD Change Limit1340273916.79619721.5
3Display Results3913910.1402792.9
 (SQL Overall)1786913917.32624391.3
 
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.