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

540 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
pliant8391882(None) 
plaint85323201plaint
plant75437111pl_ant
alant55742292al_ant
client8316342client
elint55436472eli_nt
eluant6315092eluant
flint87333502fli_nt
giant65430592_giant
glint66830182gli_nt
leant56737782_leant
liana53915892_liana
liane54720662_liane
liang64914412_liang
lint416266232_li_nt
paint75443692pai_nt
pant66061252p__ant
pedant9319492pedant
pian66136092p_ian_
piano76118712p_iano
pians75126962p_ians
pint66963172p_i_nt
plain74823302plain_
plains85019592plains
plaints94012052plaints
plait75631572pl_ait
plan65833942pl_an_
plane74929142pl_ane
planet84228352pl_anet
plank115221142pl_ank
plans75731272pl_ans
plants84921802pl_ants
plat66048872pl_a_t
pleat74734472plea_t
pliancy1435592pliancy
pliantly1345782pliantly
plight123513362plight
plink115219122pli_nk
plinth11310452pli_nth
point75338732poi_nt
print74837462pri_nt
pulsant9310562pulsant
reliant7319242reliant
riant55833152_riant
slant55238702sl_ant
splint85223282spli_nt
unpliant1047142unpliant
valiant10314622valiant
affiant1348433affiant
alan46844083al_an_
aland65526413al_and
alane56135613al_ane
alang66023513al_ang
alans55636173al_ans
alants67722023al_ants
alias55834603alia_s
alien56425583alien_
aliens65619213aliens
alight103816863alight
align65016503align_
aligns75312953aligns
aliment9316703aliment
aline57243153ali_ne
aliquant1746073aliquant
alist56136783ali_st
alit46155693ali__t
aliyot93611713aliyot
alkane104313323alkane
alkanet113714433alkanet
ant37270783___ant
apian75018333apian_
applicant1545443applicant
arrant6623253arrant
askant10412713askant
aslant6317753aslant
avant86224663_avant
avian84616053avian_
avians93711563avians
bezant17814543bezant
bint67355033_bi_nt
biont7727163_biont
blain75421793blain_
blains84516373blains
bland85320453bl_and
blank115418553bl_ank
blast76532573bl_ast
blat66550953bl_a_t
blatant9310673blatant
bleat75737003blea_t
blent76230953bl_ent
blight124114623blight
blin67228173bli_n_
blind86319323bli_nd
blini75519273bli_ni
blink115720143bli_nk
blintz1788843bli_ntz
bloat75229923bloa_t
blunt75525023bl_unt
brant74742173_brant
brisant9312683brisant
byzant2096813byzant
callant94121223callant
cant66362023__cant
chant105932693_chant
chianti1236603chianti
claimant1247483claimant
clamant11312433clamant
clan65633923cl_an_
clang86019313cl_ang
clank114719523cl_ank
clans75031013cl_ans
clapt98027173cl_apt
clast76030583cl_ast
clean75420413clean_
cleans85817053cleans
cleat76335063clea_t
clients938093clients
clift106422193cli_ft
clinal8311553clinal
cline76428533cli_ne
cling86424673cli_ng
clink115320043cli_nk
clipt96324273cli_pt
compliant1549663compliant
decant93524223decant
defiant11311923defiant
deviant11311313deviant
dint56759053_di_nt
dopant9316133dopant
elain55324703elain_
elains64919853elains
elan46734243el_an_
eland65820393el_and
elans55527753el_ans
elegant8311503elegant
elicit8417203elicit
elints65816423eli_nts
eluants737583eluants
eluent6315483eluent
eolian6312593eolian_
errant6618733errant
explant16310133expl_ant
extant132714753extant
faint85837063fai_nt
feint84732253fei_nt
fiat76646643_fia_t
flan76134183fl_an_
flank124618093fl_ank
flans85327973fl_ans
flat77147823fl_a_t
flaunt9712913flaunt
fliest94718423fliest
flight134014813flight
fling97023513fli_ng
flints95617453fli_nts
flinty126112493fli_nty
flippant1544773flippant
flirt87424753fli_rt
flit76539273fli__t
float85928573floa_t
fluent9313933fluent
galivant1247083galivant
gallant83517113gallant
gelant72821673gelant
gellant83214053gellant
giants74713503_giants
gland75217713gl_and
glans65125833gl_ans
glean65818203glean_
gleans75014743gleans
glia56423153glia__
glial66715433glia_l
glias64618493glia_s
glints75714213gli_nts
glinty106910693gli_nty
gloat65427683gloa_t
grant64840023_grant
haint85436323hai_nt
hant75461583__hant
heliast10312073heliast
hint77455743_hi_nt
ilia46026813ilia__
iliac75013483ilia_c
iliad64613453ilia_d
iliads7448673iliads
ilial55317833ilia_l
implant11311333impl_ant
incant82418503incant
infant92315133infant
joint125227723joi_nt
jurant134216553jurant
kalian10312163kalian_
kalians11310183kalians
kiang104811353_kiang
lain46146283_lain_
land56337303_l_and
lane45153323_l_ane
lang56637373_l_ang
lank84734443_l_ank
last46260323_l_ast
lat37593403_l_a_t
lean46345243_lean_
leans55536253_leans
leapt75027473_leapt
learnt64019253_learnt
least56134883_least
lent46360533_l_ent
levant9314493levant
lianas63713383_lianas
lianes63819323_lianes
liangs74410593_liangs
liar47229683_lia_r
liard65418593_liard
liars54723163_liars
licht104723493_licht
licit74327683_licit
lien45339803_lien_
liens56525503_liens
lift76942723_li_ft
ligan67920283_ligan_
ligand85011293_ligand
ligans76817733_ligans
light94429603_light
lilt46349943_li_lt
liman75921603_liman_
limans84816303_limans
limit73126333_limit
limn66527693_limn_
limns75718393_limns
lin37967373_li_n_
linac7315413_linac
line46965573_li_ne
ling57447963_li_ng
link86943443_li_nk
linn46034593_li_nn
linnet6419413_linnet
linns56123333_linns
lino46343373_li_no
lins47059053_li_ns
lints57137193_li_nts
linty87126563_li_nty
liny78141323_li_ny
lion46334443_lion_
lions55923213_lions
lirot5430033_lirot
list47055343_li_st
lit39377313_li__t
litany939053_litany
llano5910603_llano
loan47436453_loan_
loans56026463_loans
lunt46148843_l_unt
lyart85121883_lyart
meant76537203_meant
mediant103516703mediant
militant10411403militant
mint66758043_mi_nt
mutant8317693mutant
natant6318733natant
nonpliant1157873nonpliant
nutant6316383nutant
octant81216553octant
operant9317223operant
oppilant1246023oppilant
orient6322533orient
oxidant1547363oxidant
pact86648723p__act
paean77222723paean_
paeans85118263paeans
pagan86121163pagan_
pagans95717923pagans
pageant10312783pageant
pain65647243pai_n_
pains75138283pai_ns
paints85921833pai_nts
painty114714753pai_nty
paisan84417073paisan_
paisana94010223paisana
paisano9429513paisano
paisans93614743paisans
paliest93021603paliest
paling93530133pali_ng
palpitant1345313palpitant
pan58466443p__an_
pane64950283p__ane
pang75336283p__ang
pans65855723p__ans
panto76129413p__anto
pants76536923p__ants
panty105929303p__anty
parang93715513parang
parent83230423parent
parian83223963parian_
parians93519723parians
part65967463p__art
passant9813943passant
past65959013p__ast
pat58089463p__a_t
patent84524923patent
patient9617073patient
pavan106518473pavan_
pavane114113443pavane
pavans115715593pavans
pean66147173p_ean_
peans75437643p_eans
peanut8318183p_eanut
peart76440753p_eart
peasant9314923peasant
peat65967933p_ea_t
pecan91919033pecan_
pecans101515833pecans
peccant13311733peccant
pedants10310113pedants
pein65834943pei_n_
peins76128063pei_ns
pekan111613973pekan_
pekans121710553pekans
pelican1139433pelican_
pelicans1238093pelicans
peltast9310513peltast
penang92511113penang
pendant10314853pendant
pennant9312493pennant
pent66559073p__ent
perianth1348553perianth
periapt11313413periapt
phat95837863p_ha_t
phial10313203phia_l
phials1158873phials
pia56848033p_ia__
pial65636703p_ia_l
pianic103714123p_ianic
pianist9615103p_ianist
pianos84315933p_ianos
pias66542553p_ia_s
picante11310523picante
picot95031013p_icot
pignut9311573p_ignut
piing85218833p_iing
pilaf103923483pila_f
pilaff143910363pilaff
pilafs113511023pilafs
pilar75221503pila_r
pilau73618523pila_u
pilaus84114133pilaus
pilaw103913743pila_w
pilaws11399433pilaws
piling95025593piling
pilot77435063p_ilot
pin57066723p_i_n_
pina65842633p_i_na
pinang92611593pinang
pinas75434453p_inas
pinata83817213p_inata
pine67755713p_i_ne
ping75943593p_i_ng
pink107039383p_i_nk
pinna75320183p_inna
pinny105222063p_inny
pinot78737293p_inot
pins65558453p_i_ns
pinta75727053p_i_nta
pinto75625753p_i_nto
pints75936223p_i_nts
piny911838353p_i_ny
pion67235293p_ion_
pions75826393p_ions
pipet95533323p_ipet
pipit95224873p_ipit
piquant1848003piquant
pirana8713263pirana
pirn67128373p_irn_
pirns76020093p_irns
pissant91012503pissant
pit56471923p_i__t
pivot106523873p_ivot
place94824613pl_ace
placet103923673placet
plack135017843pl_ack
plage84520403pl_age
plaice10311553plaice
plaid85118303pl_aid
plaids94312443plaids
plained103812233plained
plainer93811983plainer
plainest10313613plainest
plainly1236473plainly
plaits83816473plaits
planar84212713pl_anar
planate9314573pl_anate
planch133711443pl_anch
planed94420913pl_aned
planer84122653pl_aner
planes85028083pl_anes
planets93914083pl_anets
planks124116753pl_anks
plantar9369993pl_antar
planted103516123pl_anted
planter94017803pl_anter
plash104616563pl_ash
plasm94114633pl_asm
platan83913693platan_
platane93112303platane
platans93413123platans
plate74635113pl_ate
plats75531373pl_ats
platy105021663pl_aty
play95928983pl_a_y
playa105812943pl_aya
playact1446553playact
plays106320773pl_ays
plaza164311063pl_aza
plea66830603plea__
pleach134211243pleach
plead85818463plea_d
pleads94613953pleads
pleas75627033plea_s
pleasant1048323pleasant
please84315733please
pleats85218593pleats
pleiad947833pleia_d
pleiads1045223pleiads
plena75816393pl_ena
plenty11311413pl_enty
pleon74216383pleon_
pleons84213333pleons
pliable111610323pliable
pliably14147383pliably
plica9613373pli_ca
plicae10410953plicae
plical10411683plical
plicate11314513plicate
plie65127393pli__e
plied85118593pli_ed
plier75221283pli_er
pliers84715153pliers
plies74526513pli_es
plights13299313plights
plinks124913263plinks
plinths1236123pli_nths
plisky1533713plisky
plisse8368403plisse
plonk114613983pl_onk
plot66141233pl__ot
plunk114514403pl_unk
pluvian1245333pluvian_
plying124312083plying
poignant1145743poignant
poind84217913poi_nd
pointe84619313poi_nte
points85618533poi_nts
pointy114913283poi_nty
poling93526493poli_ng
ponent82821593ponent
potent84223353potent
prang84820323p_rang
prank115019453p_rank
prat65952043p_ra_t
preact103220393preact
priapi1037923priapi
priest84125423priest
prink114719673pri_nk
prints84320103pri_nts
prion75119993prion_
prions84317783prions
privet113821343privet
ptisan8417973ptisan_
ptisans9317353ptisans
puisne856353puisne
puissant10105393puissant
puling93621403puli_ng
punt65747203p__unt
purana8712933purana
pyin96823233pyi_n_
pyins105815863pyi_ns
pyran10514473pyran_
pyrans11411063pyrans
quaint15415173quaint
quant143624813_quant
quint144529903qui_nt
radiant82817133radiant
rant45864673__rant
recant83228683recant
replant93318533repl_ant
saint55147073sai_nt
salient7419763salient
saltant7316773saltant
savant9416043savant
scant79735073_scant
secant84023293secant
sejant133114483sejant
silane62718053silane
silent64125843silent
skint95629223ski_nt
slain54923573slain_
slainte738543slainte
slang66324023sl_ang
slank95822773sl_ank
slants64819083sl_ants
slanty95114843sl_anty
slat46959023sl_a_t
sliest66621943sliest
slight103416003slight
sling66028803sli_ng
slink95422913sli_nk
slipt76627483sli_pt
slit46250103sli__t
sonant6621953sonant
spirant9814293spirant
splat76129343spl_a_t
splent84720193spl_ent
spline86020533spli_ne
splints94511743spli_nts
split75729013spli__t
sprint84526793spri_nt
stint57037663sti_nt
suint55638183sui_nt
suppliant1345183suppliant
taint55542283tai_nt
tenant6322473tenant
tint46758863_ti_nt
truant6315783truant
tyrant9315333tyrant
ulan46527393ul_an_
ulans54921303ul_ans
ulpan7310123ulpan_
ululant747693ululant
upland938863upl_and
upleapt11116863upleapt
uplift114610653upli_ft
uplight13167363uplight
uplink12388713upli_nk
uplit76020803upli__t
vacant11415133vacant
valiants1137793valiants
variant10316803variant
viand9511073_viand
volant9316323volant
volitant1147863volitant
want76156163__want

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127165405.92019039.9
3Display Results5405400.1563461.5
 (SQL Overall)1786915406.21928733.1
 
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.