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

241 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
solvent1031083(None) 
solvents1136761solvents
absolvent1454102absolvent
convent123919412convent
insolvent12136122insolvent
resolvent1246582resolvent
salient7419762salient
silent64125842sil_ent
sklent103614352skl_ent
sloven9389632sloven_
slovens10316572slovens
solve85618942solve__
solved105312932solve_d
solvency1644022solvency
solvently1544292solvently
solver94016702solve_r
solvers104414252solvers
solves95018222solve_s
solving112910852solving
sorbent92915242sorbent
splent84720192spl_ent
abluent939623abluent
absolvents1562983absolvents
advent102613753_advent
ailment9314233ailment
blent76230953_bl_ent
boldest102613063boldest
cholent12313253chol_ent
client8316343_client
cloven114211513cloven_
coagent10313983coagent
cogent9321003co_gent
coinvent1348183coinvent
coldest102514763coldest
collect113314593collect
collet84030363colle_t
comment1310317703comment
concent114422513concent
consent93723113consent
content94326153content
convect143114483convect
convene123314323convene
convents132614603convents
convert123721473convert
corvet114626933corve_t
coven106925043co_ven_
covens114919263co_vens
covert114925503co_vert
covet105638943co_ve_t
culvert123011773culvert
diluent8310263diluent
dissolvent1454573dissolvent
docent92918683do_cent
dolmen93911373dolmen_
dolmens10388693dolmens
doven94718553do_ven_
dovens104413903do_vens
eluent6315483_eluent
event85924443__event
fervent13310063fervent
fluent9313933_fluent
foment113718303fo_ment
fornent10312933fornent
forwent13310533forwent
fulgent1138903fulgent
golden84411153golden_
goldest92411173goldest
holden104113953holden_
holiest104319623holiest
holpen11299413holpen_
horrent10313553horrent
insolent81311553insol_ent
insolvents13114303insolvents
invent93316363_invent
lent46360533__l_ent
loment84021473lo_ment
molest85022743mol_est
molten83311813molten_
moment103319683mo_ment
mordent10313993mordent
nocent83217413no_cent
nonevent11410163nonevent
novena936763no_vena
obvert11412993_obvert
olden65114853_olden_
oldest72114093_oldest
orient6322533_orient
oven76624143_o_ven_
ovens86217453_o_vens
overt85630723_o_vert
polenta9310093pol_enta
pollen83416453pollen_
pollens93713303pollens
polyene1259363polyene
ponent82821593po_nent
portent93619643portent
potent84223353po_tent
prevent124016553prevent
relent64431853rel_ent
resolvents1344343resolvents
rodent7519243ro_dent
roven85521973ro_ven_
salients839563salients
sallet63734543salle_t
saltant7316773saltant
saltest71916513saltest
salve85022133salve__
salved103916423salve_d
salver94617753salve_r
salvers103916003salvers
salves94221763salve_s
salving113913153salving
sapient9415343sapient
sarment9318763sarment
savant9416043s_avant
scent75831623s__cent
segment10312563segment
select82621173sel_ect
selves94119613selve_s
sent46963013s___ent
sequent16410323sequent
serpent92916283serpent
servant10313633servant
seven84118313s_even_
sevens93813663s_evens
seventh1336773s_eventh
seventy1338033s_eventy
shaven124213303shaven_
shent85933503s__hent
sievert10613293sievert
sileni63312143sil_eni
silents73514493sil_ents
silken104410853silken_
silvan92810153silvan_
silvans10308333silvans
silver93815813silve_r
silvern10347143silvern
silvers104714043silvers
silvery13328093silvery
silvex16336723silve_x
sirvente1145023sirvente
sklents11348163skl_ents
slant55238703s_l_ant
sleet55639133s_l_eet
slept75728103s_l_ept
sliest66621963s_liest
slovenly1443853slovenly
slowest10168713slowest
slyest93811363s_lyest
soave84219053soave__
soaves94218673soave_s
sobeit8315363so_beit
socket123923523socke_t
socmen1039193socmen_
sodden84011513sodden_
soddens9348413soddens
soever94412093soeve_r
soften9429493soften_
softens10347623softens
softest10310603softest
solan55328153sol_an_
soland75115043sol_and
solano65314183sol_ano
solans64122493sol_ans
soldan73511853soldan_
soldans83210403soldans
solder73921343solde_r
solders83517773solders
sole46053673sol_e__
soled65835173sol_e_d
solei55624343sol_e_i
solely93714213sol_ely
solemn838643sol_emn
soleret7321233soleret
soles55547923sol_e_s
soleus64615613sol_eus
solfege1144223solfege
solgel737963solge_l
solicit9315743solicit
solidest9310383solidest
soling74226823sol_ing
solion6616383solion_
solions7513753solions
solleret8512223solleret
soloed74515743soloe_d
soloing82813803soloing
soloist7915893soloist
solon55026133sol_on_
solonets838233solonets
solonetz1744853solonetz
solons65120023sol_ons
solvate102710213solvate
sonant6621953so_nant
sonnet65923503sonne_t
soonest7415593soonest
sorbents10279133sorbents
sorbet83924083sorbe_t
sorest65028003so_rest
sourest7515713sourest
souvenir1142163souvenir
soviet9720153so_viet
sowens93613153so_wens
spent75532833s__pent
spleen8310263spleen_
spleens937103spleens
spleeny1234563spleeny
splents93912133spl_ents
splint85223283spl_int
sprent84522383s_prent
stent55634513s__tent
stolen64315063stol_en_
stollen747593stollen_
stollens835293stollens
student848343student
suavest10310623suavest
subrent9315083subrent
subvene1238493subvene
subvert12312893subvert
sullen62914293sullen_
sweven1235983sweven_
swevens1334613swevens
swivet123615473swive_t
swollen1034263swollen_
sylvan12257363sylvan_
sylvans13235893sylvans
sylvin12247303sylvin_
sylvine13216543sylvine
sylvins13246243sylvins
talent6323323tal_ent
toluene736463toluene
torment9316173torment
torrent7313413torrent
velvet123613753velve_t
vent76049053___vent
violent102110813viol_ent
volant9316323vol_ant
wolver12419713wolve_r
wolvers13349313wolvers
wolves124510853wolve_s
woven115215173wo_ven_
wovens12449833wo_vens

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 Limit1340272417.46617951.6
3Display Results2412410.0962510.4
 (SQL Overall)1786912417.96822426.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.