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

206 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
betaken1343828(None) 
betake124512701betake_
betakes134212521betakes
betoken13386501betoken
retaken113911801retaken
beaked135919492be_aked
beaker125520692be_aker
beaten84617062be_aten
bedarken1544512bedarken
berake124216082berake_
beraked144312432beraked
berakes134815772berakes
betaine9413782betaine
betaking153010152betaking
betaxed17307022betaxed
betokens14324572betokens
between1234682between
retake104718532retake_
retaker113714312retaker
retakes113718862retakes
rewaken144410272rewaken
taken94819142__taken
untaken1137642untaken
weaken13349602we_aken
awaken13468863_awaken
bake105637513b__ake_
baked126130773b__aked
baker115629543b__aker
bakes117035373b__akes
batiked1435963batiked
batmen104414303bat_men
batsmen1146883batsmen
batten85217123bat_ten
beacon10511373be_acon
beaded104922423be_aded
beader94623793be_ader
beadmen12299453beadmen
beak106534383be_ak__
beakers134216873be_akers
beakier134012163be_akier
beaks115326623be_ak_s
beaky146118023be_ak_y
beamed115720733be_amed
bean66443863be_a__n
beaned95621473be_aned
bearer85323913be_arer
beater84729393be_ater
beaver114819253be_aver
became123213163became_
becked155417763be_cked
becket144619883be_cket
beckon14309383be_ckon
bedamn1137813beda_mn
bedarkens1643393bedarkens
bedeafen1443343bedeafen
bedemen12910183bedemen
bedizen1935943bedizen
bedmaker1744933bedmaker
beechen14367703beechen
been65335783be___en
befallen1344033befallen
began86319573bega__n
begaze1838333begaze_
begazed2036203begazed
begazes1937963begazes
behave14209013behave_
behaved16176683behaved
behaver15206723behaver
behaves15198523behaves
belaced124112153belaced
belated103520013belated
belayed133610083belayed
belayer12339503belayer
belike124616283belike_
bellmen1138143bellmen
bemadden1443113bemadden
bename103316073bename_
benamed122911093benamed
benames112814603benames
beraking153612973beraking
berate84729023berate_
berated104422133berated
berates94126873berates
bespake15436963bespake_
bespoken16505013bespoken
beta66234133beta___
betaines10313293betaines
betas75528763beta__s
betatron1045223betatron
betatter1035453betatter
betel74419903bet__el
bethanked1943283bethanked
bethel1169643bet_hel
bethorn1238643bethorn
betide95115973betide_
betided114810203betided
betides104915263betides
betime105914833betime_
betimes115114413betimes
betise85616273betise_
betises94816123betises
betokened1643403betokened
beton76022063bet__on
betrayed1436303betrayed
betrayer1345643betrayer
betted94721163bet_ted
better84723703bet_ter
beware11313713beware_
bewared13310113bewared
bewares12313373bewares
bitchen14349733bitchen
bitten84715123bit_ten
bitumen1134503bitumen
blacken15439793blacken
bleaker133510533bleaker
boatmen1146913boatmen
bracken15409813bracken
brake116025343b_rake_
braked135318693b_raked
brakes124923123b_rakes
brazen174812453b_razen
breaker133912923breaker
brethren1343783brethren
broaden10289143broaden
broken124011523b_roken
butane8313653butane_
butanes9312743butanes
caretaken1543633caretaken
cetacean1243913cetacean
cetane8315283cetane_
cetanes9315133cetanes
deaden83714323de_aden
deafen10389673de_afen
detain74617383deta_in
eaten55323053_e_aten
etalon648973_etalon
etamin81311853_etamin
etape74413703_etape_
etapes85415293_etapes
examen1538283_examen
hearken14338023hearken
heathen133410893heathen
heaven123912603he_aven
intake10510863intake_
intakes11310943intakes
kraken955883_kraken
leaden74515223le_aden
leaked114217703le_aked
leaker104620073le_aker
leaven95013073le_aven
meatmen1138243meatmen
metage93114453metage_
metages102714973metages
metaled102913883metaled
metamer1139613metamer
metate82720533metate_
metates92720013metates
mistaken14147833mistaken
mutagen1056603mutagen
neaten64214543ne_aten
netizen1635883netizen
oaken95814383__oaken
overtaken16126633overtaken
partaken1445553partaken
peahen113410133pe_ahen
peaked136117403pe_aked
peasen84815963pe_asen
petaled103614143petaled
putamen1135923putamen
reawaken15345563reawaken
remake124016113remake_
remaker133813173remaker
remakes134116173remakes
retacked15169273retacked
retain64523283reta_in
retakers123511133retakers
retaking133114283retaking
retape83917683retape_
retaped103814283retaped
retapes93917423retapes
retaxed153512233retaxed
retaxes143615093retaxes
rewake135218463rewake_
rewaked153811903rewaked
rewakens15406243rewakens
rewakes144614983rewakes
rewoken145112293rewoken
seamen84518563se_amen
setae56026223seta_e_
shaken134113613_shaken
stake95927533_stake_
staked114621943_staked
stakes103927293_stakes
stamen84115943_stamen
take84739263__take_
taker95229003__taker
takes94437793__takes
takin94921303__takin
token95419313__token
uptake1236963uptake_
uptakes1336593uptakes
velamen1237123velamen
waken124818473__waken
weakens14367063we_akens
weaker134015443we_aker
weakon13357623we_akon

Search took 8 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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272067.06018984.0
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.28324535.4
 
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.