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

174 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
sapients103742(None) 
salients839561salients
sapiens9310171sapien_s
sapient9415331sapient_
patients1088762patients
saints65122422sa_i_nts
salient7419762salient_
saphenas1345712saphenas
sapience12106612sapience
sapiences13116422sapiences
sapiency15114492sapiency
sapiently1444862sapiently
sarments10311962sarments
satinets8311732satinets
spinets94714812s_pinets
splents93912132s_plents
absents93510723_absents
accents113511233_accents
advents11309473_advents
agents74816293_a_gents
aliens65619213_alien_s
aliments10311093_aliments
ambients1246053ambients
aments85219803_a_ments
ancients1098973ancients
aperients1178253_aperients
aplenty1237173_aplenty
appends1236393_appends
argents84014853_argents
arpents93613083_arpents
ascents93812553_ascents
aspects1146743asp_ects
aspens85013353asp_en_s
aspirants1145233aspirants
assents74512223_assents
audients946353audients
basinets1039063basinets
cabinets1238283cabinets
caplets114914523caple_ts
clients938093_clients
faciends1443573faciends
faints94818783fa_i_nts
garments1139963garments
gradients1145273gradients
haints94417583ha_i_nts
haplonts1345773haplonts
happens14359173happen_s
haptenes133810823haptenes
haptens124511343hapten_s
laments94314853la_ments
lapins84520683lapi_n_s
lappets11329123lappe_ts
latents75214313la_tents
margents11410133margents
orients7311583_orients
orpiments1346003orpiments
paints85921833pa_i_nts
papists112110453papi_sts
parents93418123pa_rents
patents94815203pa_tents
patient9617073patient_
payments1536943payments
pints75936223__pi_nts
radiants9259443radiants
raiments1039903raiments
rapiers95012873rapie_rs
rapines95120863rapi_nes
rapists92510753rapi_sts
repents93717623rep_ents
ripienos1043483ripienos
sabines94318483sabi_nes
sabins85521983sabi_n_s
sachets123914103sache_ts
saddens9309603sadden_s
sadists83310853sadi_sts
sagiest82617983sagiest_
sains55639973sa_i_n_s
saint55147073sa_i_nt_
salience10117903salience
saliences11108063saliences
saliency13125393saliency
saliently1245773saliently
salinas73116093sali_nas
salines74029413sali_nes
sallets73719653salle_ts
salpians1036763salpian_s
samiels939763samie_ls
samisens1035483samisen_s
samlets93813553samle_ts
sanies63031953sanie__s
sapheads1466083sapheads
saphena1235863saphen_a
saphenae1344853saphenae
saphenous1444873saphenous
sapidity1446433sapidity
sapiencies1445113sapiencies
sapless93313443saple_ss
saplings11269803saplings
sappers113518903sappe_rs
sappiest122612573sappiest_
sappiness1337433sappiness
sarcenets1146953sarcenets
sarins63932623sari_n_s
sarment9318763sarment_
sarmenta1047723sarmenta
sarsenets946513sarsenets
sarsens7311393sarsen_s
sarsnets836783sarsnets
sasins64923103sasi_n_s
sateens73710753sateen_s
satiety1038203satie_ty
satinet7325283satinet_
satins64930483sati_n_s
savants1038653sa_vants
savines104417633savi_nes
savings114412953savi_ngs
savins93923133savi_n_s
sayings113610833sayi_ngs
scents85317023s__cents
seapieces1344123seapieces
sediments1248213sediments
segments1138903segments
sentients948463sentients
septets998953septe_ts
sequents1756993sequents
serpents102410373serpents
shipments16254703shipments
silents73514493s_ilents
sippets113310183sippe_ts
sklents11348163s_klents
soapiest102412843soapiest_
soapiness1138293soapiness
solvents1136763solvents
sorbents10279133sorbents
soviets1087293sovie_ts
spaeings11276253spaeings
spaits85017473spai__ts
spelts84614643s_p_elts
spends94714473s_p_ends
spent75532833s_p_ent_
sphenes123013163s_phenes
spiels85317953s_pie_ls
spiers84421743s_pie_rs
spies76037623s_pie__s
spigots1037793s_pigots
spinels94512443s_pinels
spines85132033s_pi_nes
spinet85629753s_pinet_
spins75327983s_pi_n_s
spinto8410663s_pi_nto
spintos939133s_pi_ntos
spirants1088283s_pirants
spirits94112623s_pirits
spirts85317133s_pi_rts
spits74429553s_pi__ts
splent84720193s_plent_
splints94511743s_plints
sprent84522383s_prent_
sprints94113773s_prints
squints16339033squi_nts
stents65019453s__tents
stints65119763s_ti_nts
stipends11304793stipends
students954683students
subrents10310293subrents
suints64617783s_ui_nts
supines94216383supi_nes
taints64520533ta_i_nts
talents7312013ta_lents
tangents938713tangents
tappets113610013tappe_ts
valiants1137793valiants
variants1139203variants
varments1339063varments

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621746.92021121.7
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.42324072.6
 
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.