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 “solves” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
solves9501822(None) 
salves94221761salves
selves94119611selves
soaves94218671soaves
soles55547921sol_es
solve85618941solve_
solved105312931solved
solver94016701solver
solvers104414251solvers
wolves124510851wolves
absolves1344412absolves
boles75448602bol_es
calves115119282calves
cloves114918822cloves
coles76055062col_es
colies84837052colies
corves115122522corves
coves105539172co_ves
delves104917082delves
doles67843752dol_es
doves94728152do_ves
elves85118742_elves
evolves13286742evolves
folles93820472folles
gloves104115182gloves
halves124717092halves
helves124316062helves
holes84748652hol_es
holies94630032holies
hooves124815482hooves
joles125230832jol_es
loaves94813852loaves
loves85332012lo_ves
moles74747922mol_es
molies84429512molies
moves106128422mo_ves
oaves84925612_oaves
oles46453472_ol_es
olives94313952_olives
pelves114514662pelves
poles75351002pol_es
polies84034582polies
pooves113914712pooves
resolves113010782resolves
roles56747982rol_es
roves84834482ro_ves
sales56055592sal_es
salve85022132salve_
salved103916422salved
salver94617752salver
salvers103916002salvers
salvoes102811312salvoes
salvos94613382salvos
saves85838632s_aves
selles64426982selles
selvas93812912selvas
serves94423652serves
shaves125224932shaves
shelves134112092shelves
shives124921412shives
shoves124919422shoves
sieves93216002sieves
silvas92912182silvas
silver93815812silver
silvers104714042silvers
silvex16336722silvex
skives134113942skives
slaves95023022slaves
sloes54728872s_loes
slopes84820452slopes
sloven9389632sloven
slovens10316572slovens
slues54527172s_lues
soave84219052soave_
socles8418452socles
soever94412092soever
sokes95031422so_kes
solaces93116132solaces
solans64122492solans
solates73523852solates
solder73921342solder
solders83517772solders
sole46053672sol_e_
soled65835172sol_ed
solei55624342sol_ei
soleus64615612soleus
solgel737962solgel
solids74116402solids
soloed74515742soloed
solons65120022solons
solos54830792sol_os
sols45448162sol__s
solums85211332solums
solus54726982sol_us
solutes73515262solutes
solvates11249672solvates
solvent10310832solvent
solvents1136762solvents
sondes74922872sondes
sones55444142so_nes
sores55454282so_res
souses64229242souses
staves94525192staves
stoles63927672stol_es
stoves93818922stoves
swives123915182swives
sylvas12288172sylvas
toles55147132tol_es
valves124113782valves
voles86234042vol_es
voltes94915582voltes
volvas12447992volvas
wolver12419712wolver
wolvers13349312wolvers

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511142.23336968.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911142.62268150.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.