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

320 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
sapient941533(None) 
salient7419761salient
sapiens9310171sapiens
sapients1037421sapients
patient9617072patient
sagiest82617982sagiest
saint55147072sa_i_nt
salients839562salients
saphena1235862saphena
sapience12106612sapience
sapiency15114492sapiency
sapiently1444862sapiently
sappiest122612572sappiest
sarment9318762sarment
satinet7325282satinet
soapiest102412842soapiest
spent75532832s_p_ent
spinet85629752s_pinet
splent84720192s_plent
sprent84522382s_prent
absent84016993_absent
accent105116263_accent
advent102613753_advent
agent65829643_a_gent
alien56425583_alien_
aliens65619213_aliens
aliment9316703_aliment
ambient11310093ambient
ament76036543_a_ment
ancient9514733ancient
anent54931843_a_nent
aperient10715153_aperient
apian75018333_apian_
apiece10510083_apiece
aping87327233_api_ng
aplenty1237173_aplenty
append1138273_append
aptest82917513_aptest
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
ascent84519653_ascent
ashiest10313953ashiest
aspect10612823asp_ect
aspen75216093asp_en_
aspens85013353asp_ens
aspirant1048863aspirant
assent65119953_assent
attent62818323_attent
audient8312303audient
babiest114414753babiest
basinet9318933basinet
cabinet11318903cabinet
cadent94120363ca_dent
cagiest102916433cagiest
cakiest133215663cakiest
campiest142212133campiest
candent10417363candent
caplet104226813caple_t
client8316343_client
dopiest103315993dopiest
easiest72318773easiest
esurient849293esurient
faciend1334803faciend
faint85837063fa_i_nt
gamiest102816223gamiest
gaping105618923gapi_ng
gappiest13259473gappiest
garment10315233garment
gradient10310373gradient
grapiest112211923grapiest
haint85436323ha_i_nt
haplont12412563haplont
happen134812193happen_
happens14359173happens
happiest152411673happiest
hapten115312983hapten_
haptene123810933haptene
haptens124511343haptens
haziest193313003haziest
japing165013573japi_ng
laciest93819033laciest
lakiest113517263lakiest
lambent113711303lambent
lament85024943la_ment
lapin75222923lapi_n_
lapins84520683lapi_ns
lappet103817723lappe_t
latent64124303la_tent
laziest163814473laziest
lenient7313843lenient
margent10316693margent
matiest92522453matiest
maziest183613873maziest
mopiest113014293mopiest
nappiest122510883nappiest
nascent9610523nascent
oakiest112913923oakiest
orient6322533_orient
orpiment1247973orpiment
paciest112917803paciest
paint75443693pa_i_nt
paliest93021603paliest
papist102618743papi_st
pappiest112611113pappiest
parent83230423pa_rent
patent84524923pa_tent
patients1088763patients
payment14310703payment
pent66559073__p_ent
pint66963173__pi_nt
pipiest113114493pipiest
raciest92820013raciest
radiant82817133radiant
raiment9315413raiment
rapidest1138543rapidest
rapier84019993rapie_r
rapiers95012873rapiers
rapine85023083rapi_ne
rapines95120863rapines
raping94829853rapi_ng
rapini84714683rapi_ni
rapist82520673rapi_st
rappen103512713rappen_
raspiest10311273raspiest
repent84728873rep_ent
ripieni944113ripieni
ripieno944133ripieno
ropiest93317773ropiest
sabeing102611863sabeing
sabin74924953sabi_n_
sabine84020393sabi_ne
sabines94318483sabines
sabins85521983sabi_ns
sachet114725773sache_t
sadden83212403sadden_
saddens9309603saddens
saddest92412383saddest
sadist74221353sadi_st
safest95016603sa_fest
sagest74920263sa_gest
saggiest102812713saggiest
sagier73717163sagie_r
sain45551293sa_i_n_
sained75424243sa_ined
sains55639973sa_i_ns
saints65122423sa_i_nts
salience10117903salience
saliency13125393saliency
saliently1245773saliently
salina64221123sali_na
saline65132703sali_ne
salines74029413salines
sallet63734543salle_t
salpian938493salpian_
salpians1036763salpians
salpinx1636093salpi_nx
saltant7316773saltant
saltest71916513saltest
saltiest83117713saltiest
samiel8313333samie_l
samiels939763samiels
samisen937673samisen_
samisens1035483samisens
samlet84126563samle_t
sandiest93218683sandiest
sanest64426693sa_nest
sanies63031953sanie_s
saning75127643sani_ng
saphead1357773saphead
saphenae1344853saphenae
saphenas1345713saphenas
sapid84720933sapi__d
sapidity1446433sapidity
sapiences13116423sapiences
sapless93313443sapless
sapling103217863sapling
sapped114422013sappe_d
sapper103822353sappe_r
sappers113518903sappers
sappier113613113sappie_r
sapping123519313sapping
sarcenet10413313sarcenet
sarin55239253sari_n_
sarins63932623sari_ns
sarkiest123615063sarkiest
sarmenta1047723sarmenta
sarments10311963sarments
sarsen6314233sarsen_
sarsenet8412943sarsenet
sarsens7311393sarsens
sarsnet7314813sarsnet
sasin54626573sasi_n_
sasins64923103sasi_ns
sassiest83413613sassiest
sateen63815013sateen_
sateens73710753sateens
satiety1038203satiety
satin55935223sati_n_
satinets8311733satinets
sating74735453sati_ng
satins64930483sati_ns
satiny93817983sati_ny
sauciest10310973sauciest
savant9416043sa_vant
savin84625083savi_n_
savine94220283savi_ne
savines104417633savines
saving104724513savi_ng
savins93923133savi_ns
savviest1435983savviest
sawing104323813sawi_ng
sayest94217743sa_yest
saying104325543sayi_ng
scaliest101714393scaliest
scandent1148493scandent
scaping123715693scapi_ng
scariest101615943scariest
scent75831623s__cent
seamiest102715413seamiest
seapiece1244373seapiece
sediment11411103sediment
seepiest102412623seepiest
segment10312563segment
sent46963013s___ent
sentient8313633sentient
septet8921133septe_t
sequent16410323sequent
serpent92916283serpent
sexiest142112223sexiest
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415053shaliest
shapen114414653shap_en_
shaping133116183shapi_ng
shent85933503s__hent
shiest95821523s_hiest
shipment15217593shipment
silent64125843s_ilent
siping94220633sipi_ng
sippet103519393sippe_t
siziest16311473siziest
skint95629223s_ki_nt
sklent103614353s_klent
slatiest82616263slatiest
sliest66621953s_liest
snakiest122110543snakiest
snappiest1346493snappiest
soapier93411713soapie_r
soaping103616223soapi_ng
solvent10310833solvent
soppiest122511933soppiest
sorbent92915243sorbent
soupiest102212913soupiest
soviet9720153sovie_t
spaciest122310893spaciest
spaeing103413543spaeing
spait75631603spai__t
sparest94616423sparest
spaviet123011923spavie_t
spelt75430193s_p_elt
spend85619333s_p_end
sphene113412403s_phene
spied85427713s_pie_d
spiel74623913s_pie_l
spiels85317953s_piels
spier75728033s_pie_r
spiers84421743s_piers
spies76037623s_pie_s
spigot9312603s_pigot
spilt75532223s_pi_lt
spin66231303s_pi_n_
spine76534423s_pi_ne
spined95423943s_pined
spinel85317333s_pinel
spines85132033s_pines
spinets94714813s_pinets
spinny114510183s_pinny
spins75327983s_pi_ns
spinto8410663s_pi_nto
spiny104921303s_pi_ny
spirant9814293s_pirant
spirit83519923s_pirit
spirt75032953s_pi_rt
spit65545083s_pi__t
splents93912133s_plents
splint85223283s_plint
spriest92718643spriest
sprint84526793s_print
squint154214793squi_nt
stagiest91613403stagiest
stent55634513s__tent
stint57037663s_ti_nt
stipend10386553stipend
strident9310173strident
student848343student
subrent9315083subrent
suint55638183s_ui_nt
supine84216693supi_ne
supines94216383supines
swampiest1635023swampiest
taint55542283ta_i_nt
talent6323323ta_lent
tangent8314993tangent
taping94222393tapi_ng
tappet103820113tappe_t
typiest1238203typiest
unpent83117373unp_ent
upsent83314063_upsent
valiant10314623valiant
vampiest15237643vampiest
variant10316803variant
varment12313243varment
waniest103819113waniest
wariest105122503wariest
waspiest1338813waspiest
waviest134513073waviest
waxiest173510883waxiest
zaniest163214773zaniest
zappiest21228023zappiest

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 Limit1340273207.04619021.7
3Display Results3203200.1102909.1
 (SQL Overall)1786913207.56223630.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.