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

278 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
tolls5472843(None) 
atolls65511351atolls
bolls75531311bolls
dolls66126921dolls
lolls512121731lolls
molls75129781molls
polls74627721polls
rolls55326231rolls
talls55133431talls
tells55828941tells
tills54631711tills
toils54527491toils
tolas54532771tolas
toles55147131toles
toll45535261toll_
tolus55024481tolus
tolyls9436961tolyls
tools55325241tools
trolls64613941trolls
alls46740922_alls
atoll57913922atoll_
balls76236412balls
bells76432162bells
bills75632862bills
boils75427192boils
bolas74733762bolas
bolds85825282bolds
boles75448602boles
boll65634752boll_
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bowls106121432bowls
bulls75629572bulls
calls75634732calls
cells75428062cells
coals76129602coals
coils75030082coils
colas75436772colas
colds85726972colds
coles76055062coles
colly104926772colly
cols66553082co_ls
colts76633292colts
cools75632632cools
cowls106922212cowls
culls75425812culls
dells66630942dells
dills65530972dills
doles67843752doles
doll56632492doll_
dolly96125202dolly
dols56943052do_ls
dolts65626312dolts
drolls75312392drolls
dulls64523742dulls
ells46431352_ells
extolls1444602extolls
falls85727652falls
fells85327382fells
fills84632372fills
foals85721692foals
foils85025812foils
folds95221692folds
folks126017122folks
folles93820472folles
follis93113902follis
folly115022602folly
fools86824202fools
fouls87221432fouls
fowls115518892fowls
fulls84623522fulls
galls64729322galls
gills64728192gills
goals65521292goals
golds75421312golds
golfs95616102golfs
golly95121102golly
gulls65222982gulls
halls85633782halls
hells85032042hells
hills85431352hills
holds94623242holds
holes84748652holes
holks124720562holks
holla84918492holla
hollas94616902hollas
hollo84822162hollo
hollos95320632hollos
holly114824432holly
holms105117802holms
hols76946292ho_ls
holts85627912holts
howls116219222howls
hulls84923562hulls
ills47030422_ills
jells125522162jells
jills125122822jills
joles125230832joles
jolly154517512jolly
jolts125018882jolts
jowls156214522jowls
kills94526172kills
knolls10367412knolls
koels94613902koels
kohls12437802kohls
kolas94822232kolas
kolos94921212kolos
lalls55324132lalls
loll46128382loll_
lolly85120662lolly
lulls54119652lulls
malls76233432malls
mells75031332mells
mills75435052mills
moils76125752moils
molas75132092molas
molds85324832molds
moles74747922moles
moll66735702moll_
molly105222492molly
mols65948572mo_ls
molts76032092molts
mools76027172mools
mulls75124152mulls
nills54926672nills
noels56418702noels
noils55024332noils
nolos54423352nolos
nulls55019982nulls
oils46337972_oils
olds55926572_olds
oles46453472_oles
olla44821172_olla
ollas54218282_ollas
owls76022932_owls
palls74332562palls
pills74130972pills
poles75351002poles
polis74731162polis
poll66332132poll_
polos76129912polos
pols66044562po_ls
polys105718762polys
pools74427702pools
pulls74425052pulls
quolls15327302quolls
rills55032712rills
roils54826792roils
roles56747982roles
rolfs84817122rolfs
roll46331652roll_
rotls55620162rotls
sells55134432sells
sills55135992sills
soils55327982soils
soles55547922soles
solos54830792solos
sols45448162so_ls
solus54726982solus
souls55127362souls
stalls64019932stalls
stills64118572stills
stoles63927672stoles
stools65117022stools
strolls739182strolls
stulls63912982stulls
taels56822072taels
tails55634192tails
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
tall47240212tall_
tallis63319962tallis
tally84526862tally
talus55423262talus
teals56234132teals
teels55726372teels
teles54536002teles
tell44934702tell_
telly84920822telly
tellys9348842tellys
telos55424522telos
tels46841692t_els
thills95515382thills
tholes94919782tholes
tholos94213002tholos
tiles55542102tiles
till45941202till_
tils45739612t_ils
tilts55325612tilts
tirls54519802tirls
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toil46536282toil_
toile54626492toile
toiles63923512toiles
toits55327472toits
tokes95234972tokes
tola45236332to_la
tolan55124012tolan
tolans64319272tolans
tolar55524112tolar
tolars64817942tolars
told56132202to_ld
tole46052902to_le
toled65934922toled
tolled73819032tolled
toller63819442toller
tollers73217462tollers
tolu45529152to_lu
toluols735822toluols
toluyls1032832toluyls
tolyl84710092tolyl
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tones56048662tones
tongs65928462tongs
tons46553052to_ns
tonus56324302tonus
tool46735682tool_
toons55027532toons
toots55331872toots
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torts56138122torts
torus54329762torus
toss45637972to_ss
totals63115162totals
totes55139682totes
tots46654122to_ts
tours55325892tours
touts54830392touts
towels94314642towels
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
trills64319852trills
troll54416532troll_
trolly94012362trolly
trulls64110282trulls
tules54532792tules
tulle54019932tulle
tulles63218892tulles
twills9489792twills
vills86429322vills
voles86234042voles
volts85421292volts
walls85529382walls
wells85426192wells
wills84528962wills
wolds95420182wolds
wolfs116214162wolfs
wools84421462wools
yells85821942yells
yills83921552yills
yolks125412772yolks
yowls115715432yowls
zills144020782zills

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.0802233637.5
2DLD Change Limit538002781.51335558.5
3Display Results2782780.0803475.0
 (SQL Overall)1786912781.673106808.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.