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

265 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
tolas5453277(None) 
bolas74733761bolas
colas75436771colas
kolas94822231kolas
molas75132091molas
talas55935891talas
toeas55726421toeas
togas67823001togas
tola45236331tola_
tolan55124011tolan
tolans64319271tolans
tolar55524111tolar
tolars64817941tolars
toles55147131toles
tolls54728431tolls
tolus55024481tolus
toras55540371toras
alas46358122_alas
anlas55626932anlas
atlas55821582atlas
atolls65511352atolls
balas76937212balas
boas66150832bo_as
bola66035562bola_
bolar75123472bolar
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
boras75938302boras
botas75328782botas
boylas113011722boylas
cholas114818002cholas
citolas939362citolas
coalas87418962coalas
coals76129602coals
cocas95926572cocas
codas84724242codas
cola66541392cola_
colds85726972colds
coles76055062coles
cols66553082col_s
colts76633292colts
colzas174010512colzas
comas95833002comas
doblas93812292doblas
doles67843752doles
dolls66126922dolls
dolmas95213042dolmas
dols56943052dol_s
dolts65626312dolts
donas65926472donas
dopas85019062dopas
doulas75114992doulas
foals85721692foals
folds95221692folds
folks126017122folks
galas65731642galas
goals65521292goals
goas55239942go_as
golds75421312golds
golfs95616102golfs
holds94623242holds
holes84748652holes
holks124720562holks
hollas94616902hollas
holms105117802holms
hols76946292hol_s
holts85627912holts
horas86333102horas
hoyas115016162hoyas
hulas84920882hulas
hylas114815902hylas
iotas54821112iotas
joles125230832joles
jolts125018882jolts
jotas125717442jotas
koalas104011662koalas
koas85635092ko_as
kola85124962kola_
kolos94921212kolos
koras95927112koras
las37281472__las
lolls512121732lolls
lotas55926302lotas
moas65545342mo_as
mola66035632mola_
molal75120342molal
molar75223092molar
molars85517322molars
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monas74732152monas
moolas83615592moolas
moras76438782moras
moxas145014392moxas
nalas55528362nalas
nolos54423352nolos
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
ocas66729632_ocas
odas57230262_odas
okas85225392_okas
olds55926572_olds
oles46453472_oles
ollas54218282ollas
polar75623452polar
polars84419352polars
poles75351002poles
polis74731162polis
polkas1239102polkas
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rotas54827722rotas
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
sola45541862sola_
solan55328152solan
solans64122492solans
solar55927342solar
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
somas76030372somas
soras55041012soras
soyas84520912soyas
stoas55126022sto_as
stoles63927672stoles
stomas84816322stomas
tablas83716162tablas
takas95520682takas
tala45938052tala_
talar56225382talar
talars66021682talars
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tapas74627712tapas
tas38477102t__as
teals56234132teals
teas45851492t_eas
tela45532972tela_
telae54323292telae
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692tel_s
tepas76521682tepas
teslas64212172teslas
texas126514932texas
tholes94919782tholes
tholos94213002tholos
tilak91011552tilak
tilaks1097352tilaks
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
toad55830182to_ad
toads65621072toads
toast55831012to_ast
today96416952today
todays10458102todays
tods56141842to_ds
toea46732332toea_
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
toga57027412toga_
togae67020112togae
togs57242432to_gs
toiles63923512toiles
toils54527492toils
toits55327472toits
tokay125513052tokay
tokays13397772tokays
tokes95234972tokes
tolane64316582tolane
tolanes74216312tolanes
told56132202tol_d
tole46052902tol_e
toled65934922toled
toll45535262tol_l
tolu45529152tol_u
tolyl84710092tolyl
tolyls9436962tolyls
toman75724052toman
tomans85419132tomans
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tonal53724302tonal
tones56048662tones
tongas74315522tongas
tongs65928462tongs
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
topaz16315322topaz
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
tora47545992tora_
torah87125272torah
torahs95115642torahs
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382to_rs
tortas64918252tortas
torts56138122torts
torulas759852torulas
torus54329762torus
toss45637972to_ss
total55321822total
totals63115162totals
totes55139682totes
tots46654122to_ts
tours55325892tours
touts54830392touts
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
trolls64613942trolls
tronas63816902tronas
tubas75119582tubas
tufas85314382tufas
tules54532792tules
tunas54224122tunas
twas76824082t_was
violas93713522violas
volar86917412volar
voles86234042voles
volts85421292volts
volvas12447992volvas
wolds95420182wolds
wolfs116214162wolfs
yogas96615602yogas
yolks125412772yolks
zoeas145815612zoeas

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 Filter178691538000.343520965.0
2DLD Change Limit538002651.79629955.5
3Display Results2652650.0932849.5
 (SQL Overall)1786912652.23280058.7
 
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.