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

359 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
patient961707(None) 
patent84524921pat_ent
patients1088761patients
attent62818322_attent
impatient1347752impatient
inpatient1147652inpatient
latent64124302lat_ent
matiest92522452matiest
paciest112917802paciest
paint75443692pa_i_nt
paliest93021602paliest
parent83230422pa_rent
pastiest103319542pastiest
paten74827342pat_en_
patens84820862pat_ens
patents94815202pat_ents
patience1247522patience
patienter1145552patienter
patiently1445632patiently
patin76832852pati_n_
patina86022192pati_na
patine85328122pati_ne
patined105114782patined
patines95225762patines
patins87528782pati_ns
patten84418192patten_
pattens95414922pattens
patulent1048602patulent
payment14310702payment
peatiest103118802peatiest
platiest103216082platiest
potent84223352pot_ent
salient7419762salient
sapient9415332sapient
satinet7325282satinet
absent84016993_absent
accent105116263_accent
advent102613753_advent
agent65829643_a_gent
alien56425583_alien_
aliens65619213_aliens
aliment9316703_aliment
ambient11310093ambient
ament76036543_a_ment
ancient9514733ancient
anent54931843_a_nent
apartment1347033apartment
aperient10715153aperient
aptest82917513apt_est
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
artiest73121993artiest
ascent84519653_ascent
assent65119953_assent
atilt54828473_ati_lt
attend7258973_attend
attest62618613_attest
audient8312303audient
babiest114414753babiest
basinet9318933basinet
bating95132253bati_ng
batmen104414303batmen_
batten85217123batten_
battens95313263battens
battiest104115553battiest
cabinet11318903cabinet
cadent94120363ca_dent
cagiest102916433cagiest
cakiest133215663cakiest
candent10417363candent
catena8312483cat_ena
cathect1439863cathect
cation83925503cation_
cations94524143cations
catmint11314463catmint
cattiest103016333cattiest
client8316343_client
dating85326483dati_ng
detent73624483det_ent
dotiest83717453dotiest
easiest72318773easiest
eaten55323053eat_en_
eating75134403eati_ng
extent132714913ext_ent
faciend1334803faciend
faint85837063fa_i_nt
fating105328673fati_ng
fatten94314903fatten_
fattens105111713fattens
fattest102913063fattest
fattiest113514313fattiest
fitment12710303fitment
gamiest102816223gamiest
garment10315233garment
gating84826953gati_ng
gradient10310373gradient
haint85436323ha_i_nt
hastiest112916493hastiest
hating104929713hati_ng
haziest193313003haziest
hutment1239173hutment
impatiens1345733impatiens
inpatients1244293inpatients
intent63122773int_ent
kation104315683kation_
kations114013663kations
laciest93819033laciest
lakiest113517263lakiest
lambent113711303lambent
lament85024943la_ment
lateen64014863lateen_
lateens74210553lateens
laten54328343lat_en_
latens64620213lat_ens
latents75214313lat_ents
latest63822703lat_est
lathiest11312653lathiest
latina65621143lati_na
latino64120473lati_no
latten65018203latten_
lattens75014673lattens
laziest163814473laziest
lenient7313843lenient
maltiest102916193maltiest
margent10316693margent
martinet10319643martinet
matier84321523matie_r
matin75132853mati_n_
matinee92415613matinee
mating94832913mati_ng
matins84527783mati_ns
maziest183613873maziest
meatiest102816793meatiest
mitiest93520053mitiest
nascent9610523nascent
nastiest83615953nastiest
natant6318733nat_ant
nation64322803nation_
nations74720563nations
nattiest83215353nattiest
nutrient848353nutrient
oakiest112913923oakiest
oaten55222403oat_en_
orient6322533_orient
outpatient1254063outpatient
outwent10311363outwent
pacier105018683pacie_r
pacing114522753paci_ng
packet144726503packe_t
paction112713963paction_
pactions122613503pactions
pageant10312783pageant
paging104020403pagi_ng
pain65647243pa_i_n_
pained95622853pa_ined
pains75138283pa_i_ns
paintiest11310563paintiest
paints85921833pa_i_nts
painty114714753pa_i_nty
palest83926223pa_lest
palet74650803pa_le_t
palier85023563palie_r
paling93530133pali_ng
pallet84232653palle_t
palliest102814633palliest
palmiest123212023palmiest
paltriest1138603paltriest
pandect12310953pandect
pangen94115913pangen_
pangene102711963pangene
pangens103112063pangens
panier84425503panie_r
paniers94717333paniers
panini8314273pani_ni
panino8315683pani_no
pant66061263pa___nt
pantie84326473pantie__
panties94230933pantie_s
panting104025423panti_ng
papist102618743papi_st
pappiest112611113pappiest
parament12415393parament
parents93418123pa_rents
parget94529393parge_t
parian83223963parian_
parians93519733parians
paries84742513parie_s
paring94236493pari_ng
partied103516553partie_d
partier93520713partie_r
partiers103514243partiers
parties93230863partie_s
parting103527383parti_ng
partlet92720363partle_t
parturient1245383parturient
parvenu1247023parvenu
passant9813943passant
pastie85525523pastie__
pastier94320383pastie_r
pasties94529813pastie_s
pastina93914593pasti_na
pasting103826553pasti_ng
patchiest1638353patchiest
pate65350463pat_e__
pated85237843pat_e_d
patency1466313pat_ency
patented1188893pat_ented
patentee1099943pat_entee
patently1347113pat_ently
patentor1046373pat_entor
pater74740723pat_e_r
paters84935833pat_ers
pates76047893pat_e_s
patiences1367433patiences
patientest1245713patientest
patinae95414403patinae
patinas96318523patinas
patinate103016313patinate
patining11312303patining
patio74426353pati__o
patios85221783pati_os
patness92912283patness
patriot9314533patriot
patron84018043patron_
patrons93818103patrons
patsies93919483patsie_s
patted94724683patte_d
pattee84323383patte_e
pattened11299393pattened
patter84628263patte_r
pattern93712053pattern
patterns10439943patterns
patters94825193patters
pattie84020963pattie__
patties93425143pattie_s
patting103722343patting
patzer173111643patze_r
patzers184210573patzers
pavement1549443pavement
pavin105623203pavi_n_
paving124519743pavi_ng
pavins114919663pavi_ns
pawing124519553pawi_ng
pawkiest17277883pawkiest
paying123722163payi_ng
payments1536943payments
peakiest143512993peakiest
peatier94017233peatie_r
pediment13411393pediment
pendent10314723pendent
penitent10413503penitent
pent66559073p___ent
percent113520603percent
perpent112318813perpent
pertinent11412273pertinent
pestiest103018413pestiest
pestilent1148843pestilent
petit74332653peti__t
pettiest103113963pettiest
phattest1336913phattest
pigment12510733pigment
pimiento1243253pimiento
piniest93121133piniest
pint66963173p__i_nt
pipiest113114493pipiest
pithiest132711443pithiest
pitied94017253pitie_d
pitier84019823pitie_r
pitiers93812653pitiers
pities83828083pitie_s
pitmen102510793pitmen_
plaint85323203plai_nt
plangent1138803plangent
platen84518203plat_en_
platens94213983plat_ens
platier93716293platie_r
platies93722543platie_s
platina94413643plati_na
plating103823073plati_ng
pliant83918823p_liant
point75338733p_oi_nt
pokiest133314913pokiest
ponent82821593p_onent
portent93619643portent
poteen83514263poteen_
poteens92910883poteens
potion84519573potion_
potions93417423potions
potmen102713093potmen_
pottiest102815973pottiest
poutiest103016793poutiest
poxiest163412253poxiest
prating103424453prati_ng
precent113520263precent
present94022733present
prevent124016553prevent
priest84125423p_riest
print74837463p_ri_nt
prudent10310433prudent
prurient1048233prurient
pschent1437413pschent
pungent10311233pungent
puniest92918093puniest
purtiest102414113purtiest
quotient1746413quotient
raciest92820013raciest
radiant82817133radiant
raiment9315413raiment
ratine65131823rati_ne
ratines75328583ratines
rating74938703rati_ng
ration64226013ration_
rations74123433rations
ratten64217383ratten_
rattens74213403rattens
rattiest83516113rattiest
reticent10313293reticent
retint65633443reti_nt
sagiest82617983sagiest
saint55147073sa_i_nt
salients839563salients
saltiest83117713saltiest
sapiens9310173sapiens
sapients1037423sapients
sarment9318763sarment
sateen63815013sateen_
sateens73710753sateens
satiety1038203satiety
satin55935223sati_n_
satinets8311733satinets
sating74735453sati_ng
satins64930483sati_ns
satiny93817983sati_ny
sentient8313633sentient
slatiest82616263slatiest
spaciest122310893spaciest
spaviet123011923spavie_t
stent55634513_st_ent
stint57037663_sti_nt
taint55542283ta_i_nt
talent6323323ta_lent
tangent8314993tangent
tartiest82718313tartiest
tastiest83216633tastiest
tattiest83415383tattiest
tent46159863__t_ent
tint46758863__ti_nt
valiant10314623valiant
variant10316803variant
varment12313243varment
vastiest112713073vastiest
waniest103819113waniest
wariest105122503wariest
wartiest113614643wartiest
wattest102412153wattest
waviest134513073waviest
waxiest173510883waxiest
zaniest163214773zaniest

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.406440125.6
2DLD Change Limit1340273597.07618941.1
3Display Results3593590.1402564.3
 (SQL Overall)1786913597.62223444.1
 
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.