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

228 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
toeas5572642(None) 
teas45851491t_eas
toea46732331toea_
toes46956441toe_s
togas67823001togas
tolas54532771tolas
toras55540371toras
zoeas145815611zoeas
areas55935772areas
boas66150832bo_as
boheas114013212boheas
bolas74733762bolas
boras75938302boras
boreas85421732boreas
botas75328782botas
cocas95926572cocas
codas84724242codas
coeds85920162coeds
colas75436772colas
comas95833002comas
doers65225712doers
does56554472doe_s
donas65926472donas
dopas85019062dopas
fleas86423662fleas
foes76543442foe_s
foveas1238622foveas
goas55239942go_as
goers65520252goers
goes55644092goe_s
hoers85724922hoers
hoes75755732hoe_s
horas86333092horas
hoyas115016162hoyas
ideas65919012ideas
iotas54821112iotas
joes116635892joe_s
joeys15518042joeys
jotas125717442jotas
keas86337092_keas
koas85635092ko_as
koels94613902koels
kolas94822232kolas
koras95927112koras
leas45954182_leas
loess55714702loess
lotas55926302lotas
moas65545342mo_as
molas75132092molas
monas74732152monas
moras76438762moras
moxas145014392moxas
noels56418702noels
noes45845392noe_s
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
ocas66729632_ocas
odas57230262_odas
oes35866192_oe_s
okas85225392_okas
peas65755062_peas
pleas75627032pleas
poems95715552poems
poets76024442poets
rheas84816952rheas
roes45954132roe_s
rotas54827722rotas
seas45755272_seas
sheas86331792sheas
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
somas76030372somas
soras55041012soras
soyas84520912soyas
stoas55126022sto_as
stomas84816322stomas
taels56822072taels
takas95520682takas
talas55935892talas
tapas74627712tapas
tas38477102t__as
tea37353322t_ea_
teak85930842t_eak
teaks94222902t_eaks
teal45546502t_eal
teals56234132t_eals
team66238652t_eam
teams75726512t_eams
tear45242882t_ear
tears55436462t_ears
tease55428712t_ease
teat45963632t_eat
teats55636812t_eats
teds54932572t_eds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582t_ees
tegs56031492t_egs
tels46841692t_els
tens45647412t_ens
tepas76521682tepas
tets45847452t_ets
tews76431642t_ews
texas126514932texas
thens85921832thens
thetas93011572thetas
thews117416192thews
tiers55526522tiers
ties45248312tie_s
tineas64616472tineas
toad55830182to_ad
toads65621062toads
toast55831012to_ast
today96416952today
todays10458102todays
tods56141842to_ds
toe310166852toe__
toecap1037322toecap
toecaps1135552toecaps
toed56137042toe_d
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
toga57027412toga_
togae67020112togae
togs57242432to_gs
toils54527492toils
toits55327472toits
tokay125513052tokay
tokays13397772tokays
tokens104711562tokens
tokers104818892tokers
tokes95234972tokes
tola45236332tola_
tolan55124012tolan
tolans64319272tolans
tolar55524112tolar
tolars64817922tolars
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toman75724052toman
tomans85419132tomans
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tonal53724302tonal
toners64128002toners
tones56048662tones
tongas74315512tongas
tongs65928462tongs
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
topaz16315322topaz
topees85519702topees
topers85025322topers
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
tora47545992tora_
torah87125272torah
torahs95115642torahs
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382to_rs
tortas64918252tortas
torts56138122torts
torus54329762torus
toss45637972to_ss
total55321822total
totals63115162totals
totems86810762totems
toters65026362toters
totes55139682totes
tots46654122to_ts
tours55325862tours
touts54830392touts
towels94314642towels
towers94423672towers
towns86018882towns
tows78545552to_ws
toyers95516332toyers
toyos87519142toyos
toys78036342to_ys
tread64821702tread
treads74817912treads
treat56240352treat
treats64821692treats
trees55835762trees
treks96016852treks
tres46542902tre_s
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tronas63816892tronas
tubas75119572tubas
tufas85314382tufas
tunas54224122tunas
twaes86513662twaes
twas76824082t_was
tweak1257752tweak
tweaks1335962tweaks
tyees86019452tyees
tyers86220052tyers
tyes76433372tye_s
ureas55826012ureas
uveas84912282uveas
voes75432822voe_s
woes76440662woe_s
yeas78638422_yeas
yogas96615602yogas
zoea137118422zoea_
zoeae144412482zoeae
zoeal144813782zoeal

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.0931921408.6
2DLD Change Limit538002281.98627089.6
3Display Results2282280.0603800.0
 (SQL Overall)1786912282.13983539.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.