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

200 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
volts8542129(None) 
bolts76232111bolts
colts76633291colts
dolts65626311dolts
holts85627911holts
jolts125018881jolts
molts76032091molts
voles86234041voles
volt76439531volt_
volta85215621volta
volte85321301volte
voltes94915581voltes
volti84915961volti
abvolts12104372abvolts
alts46639902_alts
belts75931162belts
blots75626172blots
boats75635152boats
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
celts75325782celts
clots75627642clots
coats75635002coats
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082col_s
colt67158242colt_
coots75636842coots
costs77231142costs
cots68054842co_ts
cults75022552cults
delts65731792delts
doats65224882doats
doits66223672doits
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolt56649422dolt_
dots55647662do_ts
felts85324542felts
folds95221692folds
folks126017122folks
fonts86124752fonts
foots85528282foots
forts86034452forts
gelts65924612gelts
gilts64924262gilts
goats65527302goats
golds75421312golds
golfs95616102golfs
gouts64826172gouts
halts85230102halts
hilts86924412hilts
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holt77852582holt_
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
jilts124717412jilts
joles125230832joles
jolt116639122jolt_
jolty155713032jolty
jots116336142jo_ts
kelts95222632kelts
kilts95122182kilts
kolas94822232kolas
kolos94921212kolos
lilts55822802lilts
lofts85518362lofts
lolls512121732lolls
loots55431422loots
lots47652092lo_ts
louts56330272louts
malts76331752malts
melts74930102melts
milts75430712milts
moats75827642moats
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molt66356162molt_
molto75619602molto
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
moults84713702moults
nolos54423352nolos
nowts86915862nowts
oats46554212_oats
olds55926572_olds
oles46453472_oles
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
ovolos9257202ovolos
pelts76128812pelts
plots75025672plots
poets76024442poets
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
ports75934592ports
posts75228782posts
pots66452362po_ts
poults84613482poults
pouts75530322pouts
revolts1038892revolts
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roots55933672roots
rotls55620162rotls
rots46454092ro_ts
routs57133412routs
salts55431882salts
silts55330822silts
slots54830532slots
smolts84411882smolts
softs85019232softs
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
soots55536212soots
sorts54536662sorts
sots45552452so_ts
tilts55325612tilts
tofts84919242tofts
toits55327472toits
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
vales85434262vales
valets93715622valets
vasts86423772vasts
vats76841742v_ats
vaults94511672vaults
velds95615582velds
veldts10417752veldts
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092v_ets
vills86429322vills
violas93713522violas
violets102210002violets
viols86118102viol_s
voces105918052voces
voes75432822vo_es
voids95414672voids
voiles94616442voiles
volar86917412volar
vole75236982vol_e
voled95323722voled
volost9412642volost
volosts1036562volosts
volute93912762volute
volutes102710982volutes
volva11399002volva
volvas12447992volvas
vomits112610922vomits
vote74728622vo_te
votes84627082votes
vows106626942vo_ws
welts85225192welts
wilts85023502wilts
wolds95420182wolds
wolfs116214162wolfs
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
yolks125412772yolks

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002001.65632487.9
3Display Results2002000.0464347.8
 (SQL Overall)1786912001.79599549.3
 
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.