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

354 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
boat6636031(None) 
bat510988951b_at
beat66168301beat
blat66550951blat
bloat75229921bloat
boa56954031boa_
boar66134291boar
boart78835931boart
boas66150831boas
boast75935701boast
boats75635151boats
bolt66254171bolt
boot67759371boot
bort65960961bort
bot59680401bo_t
bota66236501bota
bott66548571bott
bout66353291bout
brat66055541brat
coat67558341coat
doat56947671doat
goat56250831goat
moat66352031moat
oat39888261_oat
abort76133582abort
about75229082about
at212393402__at
ba49962342b_a_
baa510650422b_aa
baal67033112baal
baas66844672baas
bad67763152b_ad
bag67059222b_ag
bah87755352b_ah
baht96740012baht
bait66556002bait
bal56662722b_al
bam78560142b_am
ban58366832b_an
bap76455842b_ap
bar58070552b_ar
bas58681752b_as
bast66362412bast
bate66552422b_ate
bath95940082b_ath
bats66962332b_ats
batt65053872batt
bay89661642b_ay
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beast76338642beast
beats76042242beats
beau66137272beau
beaut75135212beaut
beet66457542beet
begat86629722begat
belt65754032belt
bent67759912bent
best66355322best
bet58376672b_et
beta66234132beta
bhoot104322092bhoot
bhut95425712bhut
bias64738152bias
bint67355032bint
biont7727162biont
biota74516822biota
bit57070892b_it
bitt65545802bitt
blab86629132blab
blae66134642blae
blah98625062blah
blam86131702blam
blast76532572blast
blate75933782blate
blats75132502blats
blaw97026722blaw
bleat75737002bleat
blet66247672blet
bloats85215762bloats
blot65842322blot
bo410957572bo__
board85523002board
boars75229602boars
boarts84716872boarts
boasts85017922boasts
boated94221972boated
boatel84314092boatel
boater84622092boater
bob76755662bo_b
bobcat12411252bobcat
bobs86340642bobs
bock126032512bock
bod67055542bo_d
bode75838752bode
bods76244712bods
body107425672body
boff124727322boff
bog67852412bo_g
bogan87519002bogan
bogart9617192bogart
bogs75742752bogs
bogy106426192bogy
boho96923322boho
boil66335182boil
boite74426322boite
bola66035562bola
bolar75123472bolar
bolas74733762bolas
bold75432812bold
bole66448692bole
boll65634752boll
bolo65535952bolo
bolts76232112bolts
bomb106927422bomb
bond75334362bond
bone65949322bone
bong75633412bong
bonk105531712bonk
bony96732082bony
boo58163662bo_o
boob85932582boob
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boost75132472boost
booth105522012booth
boots75837972boots
booty106125912booty
bop77549482bo_p
bops86037982bops
bora66141632bora
boral75831702boral
boras75938302boras
borate85026152borate
borax145918722borax
bore66051332bore
bork106933822bork
born67338412born
borts76735452borts
borty105522832borty
bortz165722202bortz
bos57966812bo_s
bosh96328972bosh
bosk105825732bosk
boss65938342boss
botas75328782botas
both96533432both
bots66453952bots
botts75224862botts
bouts75131312bouts
bow87051902bo_w
bowl96827702bowl
bows96242862bows
box1210142342bo_x
boxy166420732boxy
boy87753562bo_y
boyar106013762boyar
boyo96923842boyo
boys96737332boys
bozo156821412bozo
bra56339462bra_
bract96332722bract
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
brant74742172brant
bras65746452bras
brats75336012brats
braw94829562braw
bray95232902bray
brit66350152brit
broad84817692broad
brut66537962brut
bunt65850852bunt
bust65947782bust
but55963022b_ut
butt65143742butt
cat58282342_cat
chat95546132chat
coact96130572coact
coal66939252coal
coapt96131522coapt
coast75236262coast
coati75624632coati
coats75634992coats
coax136922972coax
coft97939682coft
colt67158242colt
coot67860382coot
cost68057942cost
cot510483222co_t
doats65224882doats
doit56347852doit
dolt56649422dolt
dost57248352dost
dot47573182do_t
drat56247832drat
eat36989052_eat
fat68178082_fat
feat76458222feat
fiat76646642fiat
flat77147822flat
float85928572float
foal76630922foal
foam97127172foam
font77143752font
foot76248012foot
fort76456442fort
frat75648542frat
gat46880512_gat
ghat86435282ghat
gloat65427682gloat
gnat56034432gnat
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goats65527302goats
got49870442go_t
gout56646002gout
grat55651282grat
groat65531972groat
hat67289962_hat
heat77061422heat
hoar76729162hoar
hoax147718292hoax
holt77852582holt
hoot75752092hoot
host77852832host
hot67776052ho_t
ikat87626642ikat
iota45127832iota
jolt116639122jolt
jot108259022jo_t
jota116423622jota
kat77468292_kat
khat116730722khat
koa76737772koa_
koan85425032koan
koas85635092koas
korat94934432korat
kyat116025522kyat
lat37593402_lat
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
loath84918602loath
loft76539142loft
loot46955822loot
lost47951492lost
lot38179262lo_t
lota47233502lota
lout45952142lout
lovat8321042lovat
mat58083932_mat
meat66359602meat
moa57249182moa_
moan65832012moan
moas65545342moas
moats75827642moats
molt66356162molt
moot67653622moot
mort66758832mort
most66554202most
mot57279422mo_t
mott66648442mott
neat46356782neat
not39474662no_t
nota46830772nota
nowt78833752nowt
oaf65952882_oaf
oak76238652_oak
oar37057952_oar
oast47156322_oast
oath76132152_oath
oats46554212_oats
oba57531552oba_
obas65730932obas
obit66837072obit
oft67744062_oft
oot311274692_oot
opt57545542_opt
ort39465232_ort
out38072152_out
pat58089462_pat
peat65967932peat
phat95837862phat
plat66048872plat
poet65552902poet
port66059632port
post67953362post
pot58078432po_t
pout65752552pout
prat65952042prat
qat125253332_qat
rat37892742_rat
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
roast56230142roast
root45655922root
rot37282952ro_t
rota45834342rota
rout46153282rout
sat36288482_sat
scat65848372scat
seat47575562seat
shat76456592shat
shoat85633942shoat
skat87037892skat
slat46959022slat
soak87227662soak
soap65831132soap
soar46838672soar
soft76942822soft
soot45761052soot
sort46264812sort
sot310384292so_t
spat66548522spat
stat47352692stat
stoat57135952stoat
swat77244442swat
tat37690292_tat
teat45963632teat
that75639322that
toad55830182toad
toast55831012toast
toft77441652toft
toit46353062toit
toot45958882toot
tort46967462tort
tost48351922tost
tot38884772to_t
tout46753822tout
twat75831512twat
vat67863452_vat
volt76439532volt
wat67378922_wat
what105434072what
woad85523942woad
wont75842502wont
wort76654752wort
wost76544362wost
wot610467482wo_t
zoa128529992zoa_

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298723540.95331345.2
3Display Results3543540.0804425.0
 (SQL Overall)1786913541.109161128.0
 
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.