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

209 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
twa6772164(None) 
awa611939671awa
ta211662451t_a
taw610155451taw
tea37353321tea
twae74719571twae
twas76824081twas
twat75831511twat
two67925831two
aa219179952_aa
aba512850952aba
aga410447232aga
aha611246642aha
ala312463602ala
ama510853302ama
ana39559832ana
atma68121772atma
ava610139322ava
aw512563402aw_
away108024222away
awe67746622awe
awl67635302awl
awn68035912awn
ba49962342_ba
baa510650422baa
boa56954032boa
bra56339462bra
caw86647932caw
cwm106815082cwm
daw77148362daw
era35741502era
eta35834192eta
etna46415262etna
ewe66630982ewe
fa510148452_fa
fatwa1168062fatwa
goa47343802goa
ha510259942_ha
haw97153272haw
hwan105716892hwan
jaw136237682jaw
ka69145082_ka
kea76540912kea
koa76737772koa
la219261632_la
law68656642law
lea37660182lea
ma410060662_ma
maw87050102maw
moa57249182moa
na28652482_na
naw66346492naw
oba57531552oba
oca56731732oca
oda48133042oda
oka76926802oka
ora37250832ora
ova66823792ova
ow58950172ow_
owe67041032owe
owl66228972owl
own66429702own
pa410456482_pa
paw87651172paw
pea56657242pea
pia56848032pia
pya87023752pya
qua124821972qua
raw67252252raw
ria36745502ria
rya67622012rya
saw68255352saw
sea36161292sea
sha69837782sha
shwa106014962shwa
ska76925862ska
spa55730812spa
staw78627692staw
stoa45425912stoa
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
swat77244442swat
sway107128232sway
tab57460322tab
tad47959822tad
tae38267052tae
tag47259492tag
taj106442192taj
taka87623592taka
tala45938052tala
tam58663422tam
tan37167572tan
tao38358952tao
tap57663872tap
tapa65129142tapa
tar37570692tar
tas38477102tas
tat37690292tat
tau36856902tau
tav66043212tav
taws75641592taws
tax109449152tax
taxa116820092taxa
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
tela45532972tela
ten35856112ten
tepa66021682tepa
tet39274992tet
tew66640152tew
tews76431642tews
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
the67436052the
tho67433962tho
thy97022912thy
ti28448292t_i
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
tip56551222tip
tis37056642tis
tit36771052tit
to218858982t_o
toad55830182toad
tod49457072tod
toe310166852toe
toea46732332toea
tog410255042tog
toga57027412toga
tola45236332tola
tom514358052tom
ton310265102ton
too38965422too
top510560682top
tor39261682tor
tora47545992tora
tot38884772tot
tow610557362tow
town76928702town
tows78545552tows
towy105325472towy
toy69655192toy
trad55630912trad
tram67034552tram
trap67532802trap
tray77632592tray
try66529672try
tsar47819802tsar
tsk75814732tsk
tub55640032tub
tuba65422362tuba
tufa75016612tufa
tug45937402tug
tui37034022tui
tun35845192tun
tuna45127842tuna
tup56037542tup
tut36758092tut
tux105426572tux
twaes86513662twaes
twain86313622twain
twang94511852twang
twats86616602twats
tweak1257752tweak
twee76827082twee
twig87615772twig
twin76023082twin
twit76329062twit
twos76718022twos
tye65837442tye
tzar136315372tzar
uta37425582uta
vaw95937462vaw
via65636242via
wab87051832_wab
wad77053892_wad
wae67556952_wae
wag76451752_wag
wan66761942_wan
wap86553372_wap
war67262422_war
was68767562_was
wat67378922_wat
waw97046382_waw
wax137041182_wax
way96757662_way
we57043452_we
wha96422072wha
wo510447762_wo
ya510251502_ya
yaw97145152yaw
yea66445752yea
za1114939202_za
zoa128529992zoa

Search took 1 second 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 Filter178691140840.266671770.7
2DLD Change Limit140842090.36039122.2
3Display Results2092090.0434860.5
 (SQL Overall)1786912090.669267101.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.