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

386 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
clients93809(None) 
client8316341client_
aliens65619212alien_s
aliments10311092aliments
cements112714222cements
cents74730332c__ents
chints115117832chi_nts
cleats84919312cl_eats
clefts114610162cl_efts
cliental1045352cliental
clifts11519152cli_fts
clines84926042cli_nes
clings95716212cli_ngs
clinks125815062cli_nks
elints65816422eli_nts
eluents738702eluents
flints95617452fli_nts
glints75714212gli_nts
liens56525502_lien_s
lints57137192_li_nts
orients7311582orients
salients839562salients
silents73514492silents
abluents1045463abluents
absents93510723absents
accents113511233accents
accidents14155133accidents
advents11309473advents
agents74816293_agents
ailments1039433ailments
alants67722023al_ants
alerts64418223al_erts
alien56425583alien__
alienate8311553alienate
alienates9310683alienates
aliened81011743aliened
alienee71013153alienee
alienees8118653alienees
aliener71011193aliener
alieners889823alieners
alienism1047733alienism
alienist8411993alienist
alienists946913alienists
alienly1037503alienly
alienor7116303alienor
alienors8136733alienors
alights113211433alights
aligns75312953align_s
aliment9316703aliment_
aliners74717723aliners
alines65735223ali_nes
alkenes114212753alkenes
ambients1246053ambients
aments85219803_aments
ancients1098973ancients
argents84014853argents
arpents93613083arpents
ascents93812553ascents
assents74512223assents
audients946353audients
bents76033693__bents
bints76130183_bi_nts
bionts8612393_bionts
bleats85518613bl_eats
blends96012883bl_ends
blent76230953bl_ent_
blets75324943bl_e_ts
blights133110213blights
blinds95111613bli_nds
blinis85313683bli_nis
blinks124613573bli_nks
blintz1788843bli_ntz
bluets87215493blue_ts
blunts84512893bl_unts
brents84717273_brents
cabinets1238283cabinets
cadent94120363cadent_
cadets96316513cade_ts
cains75334303cai_n_s
cairns85313303cairn_s
calends1039523calends
callants104112143callants
callets93821703calle_ts
cants77036943c__ants
carets85330773care_ts
carnets93918403carnets
catenas9313113catenas
caveats1239803caveats
celts75325783c__elts
cement103321663cement_
cementa112810533cementa
cent67451013c__ent_
centas85020703c__entas
cento76625173c__ento
centos85920463c__entos
centu76119413c__entu
chants115020393c_hants
chaunts1267083chaunts
cheats114519543c_heats
cherts115617233c_herts
chests114916263c_hests
chianti1236613chianti
chiantis1346593chiantis
chiefs14509653chie_fs
chields13507483chields
chiels115115933chie_ls
chinas115119403chi_nas
chines115029173chi_nes
chinks155817573chi_nks
chinos115018693chi_nos
chins105631463chi_n_s
chintz204212033chi_ntz
chits105424573chi__ts
cholents1337623cholents
cines75239683c_i_nes
cions75222853c_ion_s
cists76624533c_i_sts
civets115212543c_ivets
claimants1344283claimants
clangs95113613cl_angs
clanks124615183cl_anks
clans75031013cl_an_s
clarets94111103clarets
clarinets1137683clarinets
clasts84817293cl_asts
cleans85817053cl_eans
clears84116563cl_ears
cleat76335063cl_eat_
cleeks125010543cl_eeks
clefs106616243cl_e_fs
cleft106222853cl_eft_
clement11313773clement_
clench133910053cl_ench
clepes104214623cl_epes
clept95725773cl_ept_
clerks12458843cl_erks
clevis1158963cl_evis
clews105516333cl_e_ws
cliches144213743cliches
clicks145315113cli_cks
clientage1242713clientage
clientages1342793clientages
clientele1142533clientele
clienteles1252083clienteles
clientless1272493clientless
cliffs14477593cli_ffs
clift106422193cli_ft_
climate11312833climate
climates12311973climates
climbs12498723cli_mbs
climes104720003cli_mes
clinal8311553cli_nal
clinch133910353cli_nch
cline76428533cli_n_e
cling86424673cli_n_g
clingy12659063cli_ngy
clinic104312793cli_nic
clinics11338743clinics
clink115320043cli_n_k
clips96018303cli__ps
clipt96324273cli_pt_
cliques18309203cliques
clitics11279973clitics
clivers123411753clivers
clivias1266693clivias
cloners94514823cloners
clones84526563cl_ones
clonks125013473cl_onks
clons75228133cl_on_s
clonus85212413cl_onus
cloots85113693cl_oots
closets94611603closets
clots75627643cl__ots
clouts87017203cl_outs
clowns114810113clown_s
clues74623033clue__s
clunks124811013cl_unks
coagents1138453coagents
codens94821013coden_s
cogent9321003cogent_
coignes103912153coignes
coigns94410063coign_s
coiners93620753coiners
coins75834553coi_n_s
coinvents1445663coinvents
colies84837053colie__s
colins85229043coli_n_s
collects12279783collects
collets93517903colle_ts
comets105823583come_ts
comments142913883comments
concents122516603concents
consents102715893consents
contents104018213contents
convents132614603convents
copens106119963copen_s
cornets94820573cornets
cosets85824403cose_ts
counts84618273c_ounts
covens114919263coven_s
coverts124813813coverts
covets114819643cove_ts
cozens176314923cozen_s
crests85218703c_rests
criers83918583crie_rs
cries75438403crie__s
crits75527573cri__ts
cruets85314953crue_ts
culets85518513cule_ts
cullets94015613culle_ts
culverts13295323culverts
cunts76125123c__unts
curets84922343cure_ts
currents1038373currents
cygnets1333813cygnets
cymenes1477413cymenes
dements103016623dements
dents65031803__dents
detents83615153detents
dienes75719903_dienes
diets66026643_die_ts
diluents946053diluents
dints67431313_di_nts
docents102810803docents
elects83315003el_ects
elements10312173elements
elicits9311233elicits
elint55436473eli_nt_
eluants737583eluants
eluent6315483eluent_
events94814073_events
extents142610173extents
faints94818783fai_nts
feints94813873fei_nts
fiends104110293_fiends
filets94718953file_ts
flaunts1056133flaunts
fleets96915063fl_eets
fliers94417193flie_rs
flies85630713flie__s
fliest94718433fliest_
flights143310983flights
flings106715283fli_ngs
flint87333503fli_nt_
flinty126112493fli_nty
flirts95411483fli_rts
flits85625223fli__ts
fluent9313933fluent_
foments122912053foments
friends11396743friends
gents65729613__gents
gerents82612923gerents
giants74713503_giants
gleets75315053gl_eets
glens66519853gl_en_s
glint66830183gli_nt_
glinty106910693gli_nty
haints94417583hai_nts
hents87330743__hents
hints87330623_hi_nts
incents92414533incents
indents83114663indents
intents72115703intents
invents102812053invents
joints133811453joi_nts
laments94314853laments
latents75214313latents
leets54927123_l_eets
lefts86517813_l_efts
lends65326253_l_ends
lenes54738523_l_enes
lenis56326863_l_enis
lenos56024863_l_enos
lens46146493_l_en_s
lent46360533_l_ent_
lento57223393_l_ento
lentos65317403_l_entos
lets47147943_l_e_ts
lianas63713383_lianas
lianes63819323_lianes
liangs74410593_liangs
licente91210893_licente
lichts113712383_lichts
lieges74113443_lieges
lien45339803_lien__
lienal63912783_lienal
liernes739623_liernes
liers55130403_lie_rs
lies46454193_lie__s
lieus56218483_lie_us
lifts85719063_li_fts
lights104519913_lights
likens105613703_liken_s
lilts55822803_li_lts
limens84618033_limen_s
limits82514143_limits
limns75718393_limn_s
linens64818393_linens
liners65428853_liners
lines57054573_li_nes
lings67135773_li_ngs
links96430193_li_nks
linnets739833_linnets
linns56123333_li_nns
linos55631503_li_nos
lins47059053_li_n_s
lint416266233_li_nt_
linty87126563_li_nty
lions55923213_lion_s
lisente71210703_lisente
lists56628693_li_sts
lits46252493_li__ts
livens94314893_liven_s
loments93413473loments
lunets66914763_lunets
lunts55826903_l_unts
miens76118303_mien_s
mints76834043_mi_nts
moments113113123moments
occidents14103833occidents
oleines7313393oleines
oleins6313523olein_s
orient6322533orient_
paints85921833pai_nts
parents93418123parents
patents94815203patents
patients1088763patients
pints75936223_pi_nts
plaints94012053plaints
planets93914083planets
plants84921803pl_ants
pleats85218593pl_eats
plenty11311413pl_enty
pliant83918823pliant_
pliers84715153plie_rs
plies74526513plie__s
plights13299313plights
plinks124913263pli_nks
plinth11310453pli_nth
plinths1236123pli_nths
points85618533poi_nts
priests93810863priests
prints84320103pri_nts
quiets154014373quie_ts
quints154316563qui_nts
raiments1039903raiments
regents83416543regents
relents74018503relents
rents55935183__rents
repents93717623repents
rerents73319423rerents
resents74221223resents
rodents8611543rodents
saints65122423sai_nts
salient7419763salient_
sapients1037423sapients
scents85317023_scents
silent64125843silent_
silenus7369693silenus
sklents11348163sklents
slants64819083sl_ants
sleets64318873sl_eets
sliest66621953sliest_
slieves10378963slieves
slights112810723slights
slings74618013sli_ngs
slinks104315153sli_nks
slits56128853sli__ts
solvents1136763solvents
spinets94714813spinets
splents93912133splents
splints94511743spli_nts
stents65019453_stents
stints65119763sti_nts
suints64617783sui_nts
taints64520533tai_nts
talents7312013talents
tents56434213__tents
tints56030923_ti_nts
tridents938583tridents
trienes74118413trienes
triens65417543trien_s
trientes82812123trientes
valiants1137793valiants
vents86125933__vents
wisents10249063wisents

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.1561145455.1
2DLD Change Limit1340273867.18618651.1
3Display Results3863860.1402757.1
 (SQL Overall)1786913867.48223882.8
 
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.