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

376 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
arpents9361308(None) 
argents84014851argents
arpens84814821arpen_s
arpent84822091arpent_
absents93510722absents
accents113511232accents
advents11309472advents
agents74816292a_gents
aments85219802a_ments
appends1236392appends
ardent73022612ardent_
arenas65021992ar_enas
arenes64928392ar_enes
argent74023662argent_
armets84918352arme_ts
aroints7313132aroints
aroynts1036632aroynts
arpen74418042arpen__
arrests73312682arrests
ascents93812552ascents
aspects1146742aspects
aspens85013352aspen_s
assents74512222assents
brents84717272br_ents
carpets113915332carpe_ts
garments1139962garments
margents11410132margents
orients7311582orients
parents93418122par_ents
perpents122312042perpents
rents55935182_r_ents
repents93717622repents
sarments10311962sarments
serpents102410372serpents
varments1339062varments
abets75621673a_be_ts
abluents1045463abluents
absent84016993absent_
accent105116263accent_
accepts13356353accepts
achenes12313493achenes
addends10356053addends
adepts9117103a_depts
advects13276013advects
advent102613753advent_
adverts11308513adverts
affects1535393affects
afreets1037013afreets
agenes74720253a_genes
agent65829643a_gent_
aglets73915683agle_ts
ailments1039433ailments
airports1046463airports
airposts1045923airposts
akenes104817343a_kenes
alants67722023a_lants
alerts64418223a_lerts
aliens65619213alien_s
aliments10311093aliments
alkenes114212753alkenes
alpines94016193alpines
ambients1246053ambients
amends94713283a_mends
amens75624843a_men_s
ament76036543a_ment_
amounts937043amounts
amperes11313983amperes
anapests1046613anapests
ancients1098973ancients
anenst63514983a_nenst
anent54931843a_nent_
anoints7311063anoints
ants47243473a___nts
aperients1178253aperients
apers76629133a_pe_rs
apes66047433a_pe__s
apexes1539133a_pexes
aplenty1237173aplenty
apneas83211383a_pneas
appeals11378673appeals
appears11308953appears
appels104312793appe_ls
append1138273appen_d
applets115710063applets
appoints1286403appoints
apres75426403apre__s
aprons8316993apron_s
ardebs937013arde_bs
ardency1346483ardency
ardently1247453ardently
areas55935773ar_e_as
arecas84817443ar_ecas
arena55323813ar_en_a
arene55329413ar_en_e
arenite71017713ar_enite
arenites8917103ar_enites
arenose7311373ar_enose
arenous7314183ar_enous
arepas85515703ar_epas
ares45871023ar_e__s
arete56031353ar_e_te
aretes64425353ar_etes
argental947933argental
argentic1149023argentic
argentous1045603argentous
argentum1145363argentum
argentums1243873argentums
argons75018203argon_s
argots74116033ar_gots
arguments1256573arguments
arhats9312973ar_hats
ariels65119373arie_ls
arietta788903arietta
ariettas847393ariettas
ariette7312373ariette
ariettes8411353ariettes
arles56735743arle__s
armaments1347473armaments
armers85520273arme_rs
armet76739453arme_t_
armings103811503armings
armlets94610063armlets
armpits1157133armpits
armrests1055383armrests
aroint6328153aroint_
aroynt9312893aroynt_
arrant6623253arrant_
arrears738843arrears
arrest63722633arrest_
arsenal739383arsenal
arsenals847753arsenals
arsenate81010483arsenate
arsenates979373arsenates
arsenic939323arsenic
arsenics1056763arsenics
arsenite8119663arsenite
arsenites9149163arsenites
arseno6318913arsen_o
arsenous847533arsenous
arses55733873arse__s
arsines73518823arsines
arsons63917213arson_s
artels66216233arte_ls
artists74215593artists
arts49650263ar___ts
ascends10388203ascends
ascent84519653ascent_
aspect10612823aspect_
aspen75216093aspen__
aspers86220313aspe_rs
assent65119953assent_
asserts74311793asserts
assets65617663asse_ts
attends8257593attends
attent62818323attent_
attests7278813attests
audients946353audients
augends935883augends
augments1137833augments
aunts55227633a__unts
avens86419333a_ven_s
averments1449093averments
averts95715243a_verts
barbets114915843barbe_ts
baronets101410903baronets
barrens94414323barren_s
barrets94917103barre_ts
bartends1136793bartends
bents76033693__bents
brants85723053br_ants
brens75823363br_en_s
brent75734133br_ent_
brunets9419553brunets
brunts85215453br_unts
careens94514703careen_s
carets85330773car_e_ts
carnets93918403carne_ts
carpels115315463carpe_ls
carpenter1346503carpenter
carpenters1445843carpenters
carpentry1643403carpentry
carpers114521253carpe_rs
carpet104530093carpe_t_
carpings133812393carpings
carports1238943carports
cements112714223cements
cents74730333__cents
clients938093clients
copens106119963copen_s
crests85218703cr_ests
cruets85314953crue_ts
currents1038373currents
dampens12348563dampen_s
darkens12409873darken_s
dements103016623dements
dents65031803__dents
depends11348993depends
detents83615153detents
dipnets10109033dipnets
docents102810803docents
dopants1038433dopants
earnests837853earnests
eluents738703eluents
erects84116183er_ects
errants7410643errants
events94814073_events
expects1866883expects
expends17217083expends
experts1659063experts
extents142610173extents
ferments13311473ferments
foments122912053foments
frets85523403fr_e_ts
friends11396743friends
fronts94415793fr_onts
gardens93312093garden_s
gargets94614573garge_ts
garment10315233garment_
garnets84115403garne_ts
garrets84413623garre_ts
gents65729613__gents
gerents82612923gerents
grants73722473gr_ants
greats76318393gr_eats
greens75716873green_s
greenth11116723greenth
greenths1295213greenths
greets75117423gr_eets
grunts75511853gr_unts
happens14359173happen_s
hardens113815023harden_s
harkens144112863harken_s
harpers124916203harpe_rs
harpings14379773harpings
harpins123615703harpin_s
harpists1338103harpists
harvests14246173harvests
hents87330743__hents
impends12376803impends
incents92414533incents
indents83114663indents
intents72115703intents
invents102812053invents
laments94314853laments
lappets11329133lappe_ts
latents75214313latents
loments93413473loments
margent10316693margent_
markets133314033marke_ts
marplots1245633marplots
martens93714953marten_s
moments113113123moments
mordents1138813mordents
opens76118553_open_s
orgeats838353orgeats
orient6322533orient_
orpiments1346003orpiments
orpines94414793orpines
orpins83614163orpin_s
pants76536923__pants
paraments13511553paraments
parapets1239763parape_ts
parent83230423par_ent_
pargets105215193parge_ts
parvenus1335653parvenus
patents94815203patents
patients1088763patients
payments1536943payments
peats76140193__peats
pelts76128813__pelts
pends85527193__pends
penes75839223__penes
penis75129323__penis
pens65649643__pen_s
pent66559073__pent_
percents122713373percents
perpends13227753perpends
perpent112318813perpent_
pests75933273__pests
pets66248333__pe_ts
pints75936223__pints
pipets105714773pipe_ts
portents103512823portents
precents123015043precents
preens85020113preen_s
presents103315643presents
prests84021263pr_ests
prevents133012293prevents
priests93810863priests
prints84320103pr_ints
propends13249173propends
propenes122816513propenes
punts75828003__punts
raiments1039903raiments
ramenta9311183ramenta
ramets83517393rame_ts
rants55935343_r_ants
rapers84327183rape_rs
rapes75740723rape__s
rapines95120863rapines
rapists92510753rapists
ravens93916883raven_s
reests64618893_reests
regents83416543regents
relents74018503relents
rends65129953_r_ends
rent46661243_r_ent_
rente54733783_r_ente
rentes65431193_r_entes
repeats94316053repeats
repent84728873repent_
repots85621003_repots
rerents73319423rerents
resents74221223resents
rests54935873_r_ests
rets45352563_r_e_ts
ripens85012173ripen_s
rodents8611543rodents
runts55927633_r_unts
salients839563salients
sapients1037423sapients
sarcenets1146953sarcenets
sarment9318763sarment_
sarmenta1047723sarmenta
sarsenets946513sarsenets
sarsens7311393sarsen_s
sarsnets836783sarsnets
scents85317023_scents
serpent92916283serpent_
sharpens13377813sharpen_s
silents73514493silents
sklents11348163sklents
sorbents10279133sorbents
spelts84614643_spelts
spends94714473_spends
spent75532833_spent_
splents93912133splents
sprent84522383sprent_
sprints94113773sprints
stents65019453_stents
talents7312013talents
tangents938713tangents
tappets113610013tappe_ts
targets84314223targe_ts
tarpans92513533tarpan_s
tarpons92612213tarpon_s
tents56434213__tents
terpenes102111573terpenes
torments10310453torments
torrents838143torrents
treats64821693tr_eats
treens65317873treen_s
trends75513543tr_ends
trets55928023tr_e_ts
tridents938583tridents
trienes74118413trienes
triens65417543trien_s
trientes82812123trientes
truants738163truants
unpens82511013unpen_s
unpent83117373unpent_
upends9438763_upends
urgent73816043urgent_
urtexts1433143urtexts
variants1139203variants
varlets10411573varle_ts
varment12313243varment_
varmints1335643varmints
vents86125933__vents
wardens113711903warden_s
warpers123413583warpe_rs
warrants1168503warrants
warrens103810893warren_s
wisents10249063wisents
wrens85016243wr_en_s
wrests95313083wr_ests

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273766.34321129.9
3Display Results3763760.1702211.8
 (SQL Overall)1786913766.91925826.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.