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

258 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
betook1243960(None) 
retook104313441retook
befool1137712befool
behoof1458682behoof
bemock1636172bemock
beton76022062bet_on
betons84919552betons
betony114211582betony
bettor83612222bettor
book106836332b__ook
brook114717762b_rook
ebook114510802_ebook
rebook125213202rebook
recook125513922recook
relook104813742relook
retool63914482retool
stook95218212_stook
took86531072__took
abettor956193abettor
baboo94319503baboo_
babool103012153babool
baboon103613913baboon
baboos103517013baboos
batboy1387533batboy
bathos116215633bathos
batik11614733bat_ik
baton75822423bat_on
batons85519423batons
battik1238093battik
bazoo163815673bazoo_
bazooka2242623bazooka
bazoos173212623bazoos
beacon10511373beacon
beak106534383be__ak
beano75421553beano_
beanos85516513beanos
beatnik1344863beatnik
beblood12106083beblood
bebop11410793be_bop
bebops1237623bebops
beck126226573be__ck
beckon14309383beckon
becloak1545043becloak
beclog1136863beclog
become123312593become
bedeck1536213bedeck
bedrock1645643bedrock
bedroom1247083bedroom
bedtick1645233bedtick
beetroot1047253beetroot
befog1159013be_fog
befogs1246453befogs
befools1236433befools
before11410153before
befoul1137253befoul
begloom1255243begloom
begone9512133begone
begot84625953be_got
behold1247343behold
behoove1553773behoove
behove14207203behove
behowl1445533behowl
beknot1239763beknot
bellow114213353bellow
belon73924113be_lon
belong93411043belong
belons84119413belons
below104617193be_low
belows114614183belows
bemoan10310253bemoan
bemocks1735373bemocks
benthon1237693benthon
benthos1238373benthos
bento75922953bento_
bentos86218303bentos
bentwood1444453bentwood
benzol1756993benzol
berk105929843be__rk
besmoke15416623besmoke
besnow1145713besnow
besom95716973be_som
besoms105712733besoms
besot76429713be_sot
besots86415453besots
bespoke15468113bespoke
bestow1149463bestow
bestows1248863bestows
bestrow1237253bestrow
bet58376673bet___
beta66234133bet__a
betake124512703betake
betas75528763bet_as
betel74419903bet_el
betels84515063betels
beth96629233bet__h
bethank1666273bethank
bethel1169643bethel
bethink1677203bethink
bethorn1238643bethorn
beths105519223bet_hs
betide95115973betide
betime105914833betime
betise85616273betise
betoken13386503betoken
betray111511443betray
betroth1247543betroth
bets67051443bet__s
betta74916843bet_ta
bettas84913923bettas
betted94721163betted
better84723703better
bettors93312473bettors
bevor101510813be_vor
bevors111610343bevors
beworm1339993beworm
beylik1545883beylik
beyond1237073beyond
bezoar1736913bezoar
bhoot104322103b_hoot
bittock1544433bittock
blesbok1543123blesbok
block134917843b_lock
blood85319523b_lood
bloom95918973b_loom
bloop96116153b_loop
bluebook1643393bluebook
boathook1744763boathook
bock126032513b__ock
bonk105531713b__onk
boo58163663b__oo_
boob85932583b__oob
books115729713b__ooks
boom87435673b__oom
boon67142173b__oon
boor66130683b__oor
boos67955033b__oos
boot67759373b__oot
bork106933823b__ork
bosk105825733b__osk
bottom1048723bottom
brock136017073b_rock
broo65129823b_roo_
brood84620243b_rood
brooks125813883b_rooks
broom95022213b_room
broos75126413b_roos
buteo75419893buteo_
buteos84913413buteos
buttock1545563buttock
button8310273button
bytalk1533473bytalk
bywork1834863bywork
caretook1445173caretook
chook146015043_chook
cook107236933__cook
crook115217573_crook
detick1339383detick
detour778193detour
detox13310953det_ox
dewool1047403dewool
ebooks12358333_ebooks
ethos85514193_ethos
eyehook1743343eyehook
festoon1037673festoon
fetlock1645323fetlock
fetor81214533fet_or
fetors91014473fetors
gentoo7311313gentoo_
gentoos838633gentoos
gook96429603__gook
hook116133283__hook
jeton124815403jet_on
jetons134512613jetons
jetsom15126143jetsom
jetton1338033jetton
keto86223453ket_o_
ketol95414003ket_ol
ketols104210763ketols
ketone105014533ketone
ketose105711813ketose
kook75822603__kook
look87333473__look
meteor84910073meteor
method1239033method
metol75917813met_ol
metols84115773metols
metope10611123metope
metopon11137073metopon
metro74718803metro_
metros84217803metros
mistook1337153mistook
netop7312343net_op
netops839213netops
network1446803network
nook85728493__nook
outcook1337203outcook
outlook1138023outlook
overtook15106053overtook
partook1337313partook
petcock1744603petcock
petrol82714063petrol
petto76021043petto_
pothook1656883pothook
prebook1557523prebook
precook1577803precook
ratoon64417373ratoon
rebooks134010513rebooks
reboot84119333reboot
recock145112723recock
recooks134711233recooks
recork126315493recork
redock134311543redock
reitbok1343133reitbok
relock124713523relock
relooks114010723relooks
reroof9315003reroof
resoak10311093resoak
restock1338673restock
retack122612823retack
retold73013753retold
retools73411023retools
retore67630773retore
retorn610923433retorn
retort66831153retort
retro55020953retro_
retros63820193retros
rework136619793rework
rook85532033__rook
setoff1238913setoff
seton55223543set_on
setons64620173setons
setose65114773setose
setous64917373setous
setout64719473setout
shnook1366343shnook
shook124920163_shook
snook95115573_snook
sook84933393__sook
spook115416043_spook
stock114417563_stock
stood65517713_stood
stooks105115373_stooks
stool55619893_stool
stoop75821543_stoop
stork96819693_stork
strook10410303strook
testoon748373testoon
textbook2141933textbook
too38965423__too_
tool46735683__tool
toom66532933__toom
toon47740633__toon
toot45958883__toot
unhook1347523unhook
veto76622993vet_o_
vetoed10359823vetoed
vetoer93410063vetoer
vetoes92914083vetoes

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.376475242.0
2DLD Change Limit1127162585.36021029.1
3Display Results2582580.0763394.7
 (SQL Overall)1786912585.81230745.2
 
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.