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

159 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
solvents113676(None) 
solvent10310831solvent_
absolvents1562972absolvents
convents132614602convents
insolvents13114302insolvents
resolvents1344342resolvents
salients839562salients
silents73514492sil_ents
sklents11348162skl_ents
slovens10316572sloven_s
solonets838232solonets
solvency1644022solvency
solvently1544292solvently
solvers104414252solve_rs
solves95018222solve__s
sorbents10279132sorbents
splents93912132spl_ents
abluents1045463abluents
absolvent1454103absolvent_
advents11309473_advents
ailments1039433ailments
cholents1337623chol_ents
clients938093_clients
coagents1138453coagents
coinvents1445663coinvents
collects12279783collects
collets93517903colle_ts
comments142913883comments
concents122516603concents
consents102715893consents
contents104018213contents
convects153410993convects
convenes132916913convenes
convent123919413convent_
converts133213553converts
corvets124715023corve_ts
covens114919263co_ven_s
coverts124813813co_verts
covets114819643co_ve_ts
culverts13295323culverts
diluents946053diluents
dissolvents1553113dissolvents
docents102810803do_cents
dolmens10388693dolmen_s
dovens104413903do_ven_s
eluents738703_eluents
events94814073__events
foments122912053fo_ments
insolents9137523insol_ents
insolvent12136123insolvent_
invents102812053_invents
loments93413473lo_ments
molests93311563mol_ests
moments113113123mo_ments
mordents1138813mordents
nonevents1247483nonevents
novenas1036893no_venas
obverts1235403_obverts
orients7311583_orients
ovens86217453_o_ven_s
polenta9310093pol_enta
polentas1038743pol_entas
pollens93713303pollen_s
polyenes13510063polyenes
portents103512823portents
prevents133012293prevents
relents74018503rel_ents
resolvent1246583resolvent_
rodents8611543ro_dents
salient7419763salient_
sallets73719653salle_ts
salvers103916003salve_rs
salves94221763salve__s
sapients1037423sapients
sarments10311963sarments
savants1038653s_avants
scents85317023s__cents
segments1138903segments
selects91912143sel_ects
selves94119613selve__s
sequents1756993sequents
serpents102410373serpents
servants1138003servants
sevens93813663s_even_s
seventh1336773s_eventh
sevenths1444793s_evenths
seventy1338033s_eventy
sieverts1145713sieverts
silent64125843sil_ent_
silenus7369693sil_enus
silvans10308333silvan_s
silvers104714043silve_rs
silvexes1843633silvexes
sirvente1145023sirvente
sirventes1244903sirventes
sklent103614353skl_ent_
slants64819083s_l_ants
sleets64318873s_l_eets
sloven9389633sloven__
slovenly1443853slovenly
soaves94218673soave__s
sockets134012983socke_ts
soddens9348413sodden_s
softens10347623soften_s
solands84412343sol_ands
solanos74412853sol_anos
solans64122493sol_an_s
soldans83210403soldan_s
solders83517773solde_rs
soleness8814263sol_eness
solerets839693solerets
soles55547923sol_e__s
soleus64615613sol_e_us
solfeges1244083solfeges
solicits10311023solicits
solions7513753solion_s
sollerets945263sollerets
soloists869153soloists
solonetz1744853solonetz
solons65120023sol_on_s
solvate102710213solv_ate
solvates11249673solvates
solve85618943solve___
solved105312933solve__d
solvencies1544803solvencies
solventless1451273solventless
solver94016703solve__r
solving112910853solvin_g
sonants7511233so_nants
sonnets74211993sonne_ts
sorbent92915243sorbent_
sorbets93012513sorbe_ts
souvenir1142163souvenir
souvenirs1242423souvenirs
soviets1087293so_viets
sowens93613153so_wen_s
spleens937103spleen_s
splent84720193spl_ent_
splints94511743spl_ints
stents65019453s__tents
stollens835293stollen_s
students954683students
subrents10310293subrents
subvenes1339633subvenes
subverts1336973subverts
swevens1334613sweven_s
swivets13436963swive_ts
sylvans13235893sylvan_s
sylvines14215903sylvines
sylvins13246243sylvin_s
talents7312013tal_ents
toluenes836763toluenes
torments10310453torments
torrents838143torrents
velvets13326693velve_ts
vents86125933___vents
wolvers13349313wolve_rs
wolves124510853wolve__s
wovens12449833wo_ven_s

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.420425454.8
2DLD Change Limit1461621597.44019645.4
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.92322553.5
 
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.