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

336 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
kob9944238(None) 
bob76755661bob
cob710258751cob
fob86748331fob
gob68950891gob
hob87550921hob
job128041771job
kab97145851kab
knob107417011knob
koa76737771koa
kobo107422101kobo
kobs105831081kobs
koi77534741koi
kop97440201kop
kor76538891kor
kos76944821kos
lob57154461lob
mob78651911mob
nob58954421nob
rob56754301rob
sob57857941sob
yob87945271yob
ab410674762_ab
abo59045962abo
alb57342652alb
arb510448422arb
bib77045922bib
blob86027092blob
bo410957572bo_
boa56954032boa
bobs86340642bobs
bod67055542bod
bog67852412bog
bomb106927422bomb
boo58163662boo
boob85932582boob
bop77549482bop
bos57966812bos
bot59680402bot
bow87051902bow
box1210142342box
boy87753562boy
bub76343972bub
cab78355402cab
cobb106421992cobb
cobs87043142cobs
cod69660122cod
cog69552902cog
col59360352col
comb106632112comb
con510268022con
coo59566362coo
cop711162372cop
cor59960942cor
cos510270392cos
cot510483222cot
cow89856712cow
cox1210346782cox
coy810557552coy
coz149345362coz
cub76940942cub
dab67455562dab
deb66342692deb
dib65746932dib
do310155252do_
doby106022162doby
doc66841512doc
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
dow76749972dow
dub66642202dub
ebb72418622ebb
eon36052082eon
fab87453132fab
fib86344262fib
fobs96034272fobs
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
forb97131332forb
fou66743782fou
fox136737862fox
foy96044262foy
fub86337392fub
gab67155992gab
gib66443522gib
glob76623392glob
go38748742go_
goa47343802goa
gobo76126892gobo
gobs76935572gobs
goby106021082goby
god57449792god
goo47754772goo
gor47848262gor
gos47155132gos
got49870442got
gox117137182gox
goy77844552goy
ho510258272ho_
hobo97026082hobo
hobs97038982hobs
hod76852462hod
hoe67562722hoe
hog78049062hog
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
hoy97447912hoy
hub86437482hub
ikon85814952ikon
ion36051022ion
jab128444112jab
jib125835962jib
jo99539602jo_
jobs136529432jobs
joe106642352joe
jog117438312jog
jot108259022jot
jow137639302jow
joy137036362joy
ka69145082k_a
kabob134113922kabob
kabs107130842kabs
kae76744542kae
kaf106845512kaf
kaon87521022kaon
kas77058582kas
kat77468292kat
kay106745542kay
kea76540912kea
kebob135110912kebob
kef105639662kef
keg86432532keg
ken76343982ken
kep96437202kep
kerb104322712kerb
kex146029582kex
key105833332key
khi106318302khi
ki67537952k_i
kibe106523432kibe
kid86540612kid
kif105941172kif
kin76353962kin
kip97042132kip
kir76535672kir
kis78051472kis
kit78559872kit
knobs11519712knobs
knop107116592knop
knot85630502knot
know116115842know
koan85425032koan
koas85635092koas
kobos115616892kobos
koel84519942koel
kohl113911712kohl
kois85129392kois
koji155611112koji
kola85124962kola
kolo87026222kolo
kombu1347242kombu
konk79320612konk
kook75822602kook
koph135816542koph
kops107031292kops
kora86431552kora
kore85834162kore
kors85933012kors
koss85224812koss
koto86323462koto
kue76631862kue
kye107327272kye
lab58864782lab
lib57750262lib
lo28053442lo_
lobe65535362lobe
lobo67229862lobo
lobs66441082lobs
log46252682log
loo38359822loo
lop58255312lop
lot38179262lot
low66051872low
lox108240962lox
mib76946102mib
mo49158482mo_
moa57249182moa
mobs85737362mobs
moc77845082moc
mod69054402mod
mog66949672mog
mol56654592mol
mom78853162mom
mon57561572mon
moo58460512moo
mop76950822mop
mor56855002mor
mos57067122mos
mot57279422mot
mow86650352mow
nab56954922nab
neb57238622neb
nib56745182nib
no29353242no_
nobs66436902nobs
nod47549562nod
nog46847312nog
noh66640642noh
nom510450642nom
noo37154042noo
nor38048822nor
nos38859322nos
not39474662not
now65950192now
nub56439142nub
oba57531552_oba
obe56638642_obe
obi57127722_obi
od39255242_od
oe28473062_oe
of58247772_of
oh57447002_oh
oi29061482_oi
oka76926802oka
oke75839482oke
om48553002_om
on28057182_on
ooh67637092ooh
oot311274692oot
op45850162_op
or27354732_or
orb55736862orb
os211359882_os
ow58950172_ow
ox98242382_ox
oy58950132_oy
pod66351482pod
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pot58078432pot
pow87147282pow
pox126140692pox
pub76037692pub
reb55844962reb
rib56848022rib
robe65335642robe
robs65837872robs
roc520243252roc
rod47953892rod
roe36861072roe
rom59855632rom
rot37282952rot
row67453672row
rub56342822rub
sab56563202sab
sib56850302sib
slob66029422slob
snob65825592snob
so28855442so_
soba64927922soba
sobs64941752sobs
sod46053702sod
sol37256622sol
som59153802som
son37761952son
sop57557862sop
sorb68333042sorb
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
sox106444192sox
soy67851452soy
stob66724612stob
sub55445552sub
swob95218632swob
tab57460322tab
to218858982to_
toby96322292toby
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
tomb89029652tomb
ton310265102ton
too38965422too
top510560682top
tor39261682tor
tot38884772tot
tow610557362tow
toy69655192toy
tub55640032tub
urb55731102urb
voe67739052voe
vow96136312vow
vox136628152vox
wab87051832wab
web85735562web
wo510447762wo_
woe66651242woe
wog76242732wog
wok106334172wok
womb117022232womb
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
yo59748552yo_
yobs96028082yobs
yod77545502yod
yok107335242yok
yom88043442yom
yon67348952yon
you66641822you
yow96945292yow
zoa128529992zoa
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.0632836365.1
2DLD Change Limit140843360.39036112.8
3Display Results3363360.0605600.0
 (SQL Overall)1786913360.513348325.5
 
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.