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

177 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
two6792583(None) 
tao38358951tao
tho67433961tho
to218858981t_o
too38965421too
tow610557361tow
twa67721641twa
twos76718021twos
wo510447761_wo
abo59045962abo
ado49146872ado
ago48845522ago
apo511142122apo
avo68936232avo
aw512563402aw_
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
awol75620672awol
azo128233392azo
bio57846072bio
bo410957572_bo
boo58163662boo
bow87051902bow
bro56236602bro
coo59566362coo
cow89856712cow
cwm106815082cwm
do310155252_do
dow76749972dow
duo48536142duo
ego46726052ego
ewe66630982ewe
fro65530642fro
go38748742_go
goo47754772goo
hao67251122hao
ho510258272_ho
how97252432how
jo99539602_jo
jow137639302jow
lo28053442_lo
loo38359822loo
low66051872low
mho86624622mho
mo49158482_mo
moo58460512moo
mow86650352mow
no29353242_no
noo37154042noo
now65950192now
oho66534382oho
ono36838032ono
otto45220642otto
ow58950172ow_
owe67041032owe
owl66228972owl
own66429702own
oxo107322962oxo
poo57757112poo
pow87147282pow
pro55837262pro
rho65924832rho
row67453672row
so28855442_so
sow66554762sow
stow77325742stow
swob95218632swob
swop95120502swop
swot75134652swot
ta211662452t_a
tab57460322tab
taco67031352taco
tad47959822tad
tae38267052tae
tag47259492tag
taj106442192taj
tam58663422tam
tan37167562tan
taos45541002taos
tap57663872tap
tar37570692tar
taro46846912taro
tas38477102tas
tat37690292tat
tau36856902tau
tav66043212tav
taw610155452taw
taws75641592taws
tax109449152tax
tea37353322tea
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
ten35856112ten
tet39274982tet
tew66640152tew
tews76431642tews
the67436052the
thio77225412thio
thou76722212thou
thro77726422thro
thy97022912thy
ti28448292t_i
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
tip56551222tip
tiro46832362tiro
tis37056642tis
tit36771042tit
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
took86531072took
tool46735682tool
toom66532932toom
toon47740632toon
toot45958882toot
top510560682top
topo66932402topo
tor39261682tor
toro48045682toro
tot38884772tot
town76928702town
tows78545552tows
towy105325472towy
toy69655192toy
toyo76925452toyo
trio45233342trio
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trow78031422trow
troy77429682troy
try66529672try
tsk75814732tsk
tub55640032tub
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
tut36758092tut
tux105426572tux
twae74719572twae
twas76824082twas
twat75831512twat
twee76827082twee
twig87615772twig
twin76023082twin
twit76329062twit
tye65837442tye
typo95418122typo
tyro76622362tyro
udo49027302udo
upo58925862upo
vow96136312vow
we57043452_we
who95526772who
woe66651242_woe
wog76242732_wog
wok106334172_wok
won66252062_won
woo66949802woo
wop87145132_wop
wos66953532_wos
wot610467482_wot
wow96643472_wow
yo59748552_yo
yow96945292yow
zoo126238912zoo

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.0602978183.3
2DLD Change Limit140841770.36039122.2
3Display Results1771770.0463847.8
 (SQL Overall)1786911770.466383457.1
 
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.