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 “atween” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

231 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
atween916661(None) 
tween84413741_tween
atwain937812atwain
awee76336642a_wee_
between1234682between
etwee84115332etwee_
etwees9348792etwees
lateen64014862lat_een
ratteen7329112ratteen
sateen63815012sat_een
teen45938202_t_een
treen55622752_treen
twee76827082_twee_
tweed94915092_tweed
tweens9489842_tweens
tweeny12477002_tweeny
tweet84823982_tweet
ween75835462__ween
achene11313813achene
ackee115825363ackee_
ackees124914573ackees
acumen1049013acumen
adeem8311803a_deem
admen84516183a_dmen
adwomen1345683adwomen
aeon45634613a__eon
afreet9315153afreet
agee56241493a_gee_
agene65621583a_gene
aglee65728493aglee_
agree65226033agree_
agreed84712503agreed
agrees74915323agrees
aidmen92610373aidmen
airmen82612353airmen
ajee115928233a_jee_
akee85936813a_kee_
akees96119243a_kees
akene95818663a_kene
alee46652323a_lee_
alien56425583a_lien
alkene104114003alkene
allee54932123allee_
allees64521483allees
ambeer104511603ambeer
ameer75618983a_meer
amen66733153a__men
anteed75616113anteed
antigen8311123antigen
antiweed1246303antiweed
apeek114711873a_peek
arene55329413a_rene
arisen65316793arisen
arpen74418043a_rpen
ashen87818673a_shen
ashmen1168173ashmen
asleep847283asleep
aspen75216093a_spen
astern64815813astern
aswoon947013aswoon
ataman81013063ataman
ate37059243at__e_
ates45047923at__es
atman75520143at_man
atone56527983atone_
atoned75417543atoned
atoner64817193atoner
atones65225773atones
attain6311753attain
attend7258973attend
attent62818323attent
attest62618613attest
attorn6310793attorn
attune637983attune
automen939653automen
autopen947123autopen
awaken13468863awaken
awe67746623a_w_e_
awed88436033a_w_ed
aweing103911253a_weing
awes76037553a_w_es
awn68035913a_w__n
awned96615953a_wned
awoken13457163awoken
axemen1547493axemen
axmen145112273a_xmen
axseed1456993axseed
baleen8613053baleen
batmen104414303bat_men
batsmen1146883batsmen
batten85217123bat_ten
been65335783__been
beweep13147253beweep
boreen8314313boreen
bowmen1399853bowmen
canteen9411083canteen
careen84119493careen
cowmen13810923cowmen
dasheen1136393dasheen
dawen95413723daw_en
dudeen857173dudeen
dweeb1137743_dweeb
eaten55323053eat__en
ethene93312923ethene
fatten94314903fat_ten
gatemen1047603gatemen
green65522143_green
kamseen1344013kamseen
keen84830403__keen
lateens74210553lat_eens
laten54328343lat__en
latten65018203lat_ten
lawmen11308593lawmen
mayweed1634163mayweed
moreen8313343moreen
nankeen1135043nankeen
ngwee9311073ngwee_
oaten55222403oat__en
outseen72712333outseen
outweep1236673outweep
owsen84210193_owsen
paten74827343pat__en
pattee84323383pattee_
patten84418193pat_ten
pattern93712053pattern
peen65938083__peen
pewee10319973pewee_
pewees11311393pewees
poteen83514263poteen
potheen12257893potheen
potteen9319673potteen
preen75925053_preen
queen144312063_queen
ragweed1235073ragweed
ratteens8256053ratteens
ratten64217383rat_ten
reseen64318413reseen
rowen84921153row_en
sateens73710753sat_eens
screen85216013screen
seen46943123__seen
sheen85023313_sheen
skeen94817403_skeen
spleen8310263spleen
stamen84115943stamen
steed66024943st_eed
steek95418003st_eek
steel55721993st_eel
steep76020703st_eep
steepen9348653steepen
steer55423863st_eer
stein54620543st_ein
stern55319123st_ern
stewed104814243stewed
stolen64315063stolen
streek104111413streek
streel64214023streel
street64125773street
strewn96710003strewn
sweeny12358843_sweeny
sweep104715723_sweep
sweer84918573_sweer
sweet85330523_sweet
sweven1235983_sweven
taken94819143_taken
tamein8313093tamein
tarweed1137343tarweed
tauten64311893tauten
tavern9428933tavern
tawed95926193taw_ed
tawer85223443taw_er
tawers94118603tawers
tawie84819813tawie_
tawney12338233tawney
tawse85616503tawse_
tawsed10499743tawsed
tawses94913193tawses
taxmen15367443taxmen
tee38366873_t_ee_
teed55439263_t_eed
teel46335803_t_eel
teem66132603_t_eem
teens56227483_t_eens
teeny85417883_t_eeny
tees45353583_t_ees
ten35856113_t__en
tern46134803_t_ern
tewed94718533_tewed
thee78039063_thee_
thegn95810903_thegn
thein85919023_thein
then78429693_t_hen
token95419313_token
tree47745813_tree_
treed65626733_treed
treens65317873_treens
trees55835763_trees
tureen63312723tureen
twae74719573_twae_
twaes86513663_twaes
twain86313623_twain
tweak1257753_tweak
tweeds10498433_tweeds
tweedy13455933_tweedy
tweener10306833_tweener
tweets94210103_tweets
tweeze18265473_tweeze
twerp10398413_twerp
twier84713293_twier
twin76023083_tw_in
twine85822363_twine
twyer11558523_twyer
tyee75131423_tyee_
tyees86019453_tyees
unseen62012623unseen
waxweed2132923waxweed
wean75734353__wean
wee66760813__wee_
weed85637513__weed
week116428153__week
weel75834083__weel
weens85224053__weens
weeny115316163__weeny
weep95131653__weep
weer75535093__weer
wees76249123__wees
weet75254153__weet
wen66249603__w_en
wheen115016053_wheen
when105723043__when
wren78221683__wren

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162315.48620546.1
3Display Results2312310.0603850.0
 (SQL Overall)1786912315.68631426.5
 
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.