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

289 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
orb5573686(None) 
arb510448421arb
forb97131331forb
or27354731or_
ora37250831ora
orbs66626251orbs
orby97519601orby
orc57034921orc
ore36661831ore
ors35750111ors
ort39465231ort
rob56754301rob
sorb68333041sorb
urb55731101urb
ab410674762_ab
alb57342652alb
ar211379382ar_
arbs66834732arbs
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
barb85240062barb
bib77045942bib
bob76755672bob
bomb106927422bomb
boob85932582boob
bora66141632bora
bore66051332bore
bork106933822bork
born67338412born
bort65960962bort
bra56339462bra
bro56236602bro
brr56921922brr
bub76343982bub
burb85334672burb
cab78355402cab
carb85143162carb
cob710258752cob
cobb106422002cobb
comb106632112comb
cor59960942cor_
corby125018532corby
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
cory96941512cory
crab85727672crab
crib86323582crib
cru57129562cru
cry89726242cry
cub76940942cub
curb86732222curb
dab67455562dab
darb76033532darb
deb66342692deb
dib65746942dib
dor47253922dor_
dore56353302dore
dork96531462dork
dorm76834622dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
drab76226452drab
drib76823262drib
drub75920132drub
dry76526032dry
dub66642202dub
ebb72418632ebb
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738352ern
err35626532err
ers36046282ers
fab87453132fab
fib86344272fib
fob86748332fob
for66952072for_
fora75937392fora
forbs105720802forbs
forby135317672forby
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
fro65530642fro
fry96226502fry
fub86337392fub
gab67155992gab
garb75332672garb
gib66443532gib
gob68950892gob
gor47848262gor_
gore55744962gore
gorm75529392gorm
gorp75625902gorp
gory86129662gory
grab75427612grab
grub77220082grub
herb94730962herb
hob87550922hob
hora76136552hora
horn76735612horn
hub86437482hub
ire36943172ire
irk76426362irk
jab128444112jab
jib125835972jib
job128041772job
kab97145852kab
kerb104322712kerb
kob99442382kob
kor76538892kor_
kora86431552kora
kore85834162kore
kors85933012kors
lab58864782lab
lib57750272lib
lob57154462lob
lord55032082lord
lore45850352lore
lorn46435252lorn
lory75931712lory
mib76946122mib
mob78651922mob
mor56855002mor_
mora66641272mora
more67154522more
morn66237562morn
mors65950062mors
mort66758832mort
nab56954922nab
neb57238622neb
nib56745192nib
nob58954422nob
nor38048822nor_
nori47133142nori
norm66429812norm
nub56439142nub
oaf65952882oaf
oak76238652oak
oar37057952oar
oars46846032oars
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
ogre56320742ogre
oh57447002o_h
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
okra86413572okra
old47033462old
ole37155212ole
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
orad56031692orad
oral47638122oral
orbed85516192orbed
orbit73622062orbit
orca65522772orca
orcs67025432orcs
ordo54622352ordo
ores46056682ores
orgy85218002orgy
oribi7311092oribi
orle45630462orle
orra46120722orra
orts46538332orts
oryx14510212oryx
orzo134516782orzo
os211359882o_s
ose38147342ose
oud47439072oud
our36042892our
ours47237562ours
out38072152out
ova66823792ova
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pore66451262pore
pork106929682pork
porn65636022porn
port66059632port
pro55837262pro
pry85728052pry
pub76037692pub
re26153742_re
reb55844962reb
rib56848032rib
robe65335642robe
robs65837872robs
roc520243252roc
rod47953892rod
roe36861072roe
rom59855632rom
rot37282952rot
row67453672row
rub56342822rub
sab56563202sab
sib56850312sib
sob57857942sob
sora45746912sora
sorbs75022102sorbs
sord56237202sord
sore47059532sore
sori46039832sori
sorn46641062sorn
sort46264812sort
sri35634002sri
sub55445552sub
tab57460322tab
tomb89029652tomb
tor39261682tor_
tora47545992tora
torc66333352torc
tore47359322tore
tori47542152tori
torn46044252torn
toro48045682toro
torr45630902torr
tors46157382tors
tort46967462tort
tory75840542tory
try66529672try
tub55640032tub
urbs65922052urbs
urd46427042urd
urn35731462urn
urp56426392urp
verb96224872verb
wab87051832wab
web85735562web
womb117022232womb
word89832002word
wore77144672wore
work115528842work
worm96129482worm
worn75631752worn
wort76654752wort
wry96524702wry
yob87945272yob
yore76335942yore
zori137722922zori

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 Limit140842890.45331090.5
3Display Results2892890.0466282.6
 (SQL Overall)1786912890.562317955.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.