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

319 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
abos6773441(None) 
abas68642081abas
abo59045961abo_
abs59356071ab_s
abys97221881abys
ados57633511ados
ambos95321251ambos
apos65433821apos
avos77227011avos
bos57966811_bos
aahs716428562aahs
aals49941142aals
aas310975392a_as
ab410674762ab__
aba512850952ab_a
abase76023482abase
abash106016512abash
abba810522652abba
abbas95918642abbas
abbe87627192abbe
abbes96723522abbes
abbot9318452abbot
abbots1039282abbots
abed79734132abed
abet610547942abet
abets75621672abets
abhor10411062abhor
abhors11410622abhors
able66340532able
ables75935542ables
ably99725132ably
abmhos1334972abmhos
abode85518812abode
abodes94417512abodes
abohm1247972abohm
abohms1335002abohms
aboil72217542aboil
aboma91114602aboma
abomas101113582abomas
aboon74918702aboon
abort76133582abort
aborts84916182aborts
about75229082about
above105414322above
aboves114512842aboves
abri65522212abri
abris75722602abris
abuse77119562abuse
abut66834952abut
abuts75417072abuts
aby810238062ab_y
abye97921002abye
abyes105518532abyes
abysm12598142abysm
abyss10669462abyss
aces67645092aces
acts66929862acts
adds67622452adds
adios65822862adios
ado49146872ado_
adobos9438452adobos
ads49755732a_ds
aeon45634612aeon
aeons57624652aeons
agas55938842agas
ages55844592ages
agios65919862agios
ago48845522ago_
agog68019002agog
agon56531882agon
agons66423782agons
ags47551662a_gs
ahis76135382ahis
ahoy101919182ahoy
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
alas46358122alas
albas75925392albas
albs68628572albs
ales47067102ales
alls46740922alls
alms65834922alms
aloe45540192aloe
aloes54933672aloes
alow75328592alow
alps65529242alps
als36663022a_ls
also46423442also
altos55822952altos
alts46639902alts
amas67746292amas
ambo88225142ambo_
amis66445322amis
ammos94815822ammos
amok10217402amok
amoks11413552amoks
amps86230342amps
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
anoa45634472anoa
anoas57226492anoas
anon46134852anon
ants47243472ants
anus47131112anus
apes66047432apes
apo511142122apo_
apod78123182apod
apods86316342apods
apps86319692apps
arbor74818112arbor
arbors84717872arbors
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
arose55832082arose
ars37670932a_rs
arts49650262arts
arvos86015662arvos
as211083072a__s
askos95011772askos
asks85721212asks
asps65622092asps
ass37844062a_ss
ates45047922ates
atom67824522atom
atoms76817562atoms
atop66124752atop
auks85525262auks
autos56523322autos
aves76142602aves
avo68936232avo_
avow107816462avow
avows114910982avows
awes76037552awes
awls75926092awls
awns75324432awns
awol75620672awol
awols84713522awols
axes117337852axes
axis116127912axis
axon115524302axon
axons125517932axons
ayes76543512ayes
ays67050292a_ys
azo128233392azo_
azon135725052azon
azons146518252azons
baas66844672baas
babas96325732babas
babes95834112babes
baboo94319502baboo
baboos103517012baboos
babus95620332babus
bads77048862bads
bags76645502bags
bals66354042bals
bams87044452bams
bans66555132bans
baps86040842baps
bars66564092bars
bas58681752_bas
bass66146782bass
bats66962332bats
bays97143912bays
bes56557432_bes
bios66335322bios
bis56860662_bis
bo410957572_bo_
boa56954032_boa
boas66150832_boas
bob76755672_bob
bobs86340652_bobs
bod67055542_bod
bods76244712_bods
bog67852412_bog
bogs75742752_bogs
boo58163662_boo
boos67955032boos
bop77549482_bop
bops86037982_bops
bosh96328972_bosh
bosk105825732_bosk
boss65938342_boss
bot59680402_bot
bots66453952_bots
bow87051902_bow
bows96242862_bows
box1210142342_box
boy87753562_boy
boys96737332_boys
bros65635662bros
bus56950972_bus
bys85229462_bys
cabob114616812cabob
cabobs124311892cabobs
cabs86739422cab_s
calos74431902calos
camos95927612camos
capos94826072capos
carbos105122262carbos
cobs87043142cobs
coos67456492coos
cos510270392_cos
dabs77139402dab_s
dados75522432dados
dagos76419442dagos
datos65222782datos
dos48062312_dos
duos56728132duos
ebbs82411992ebbs
ebon66821102ebon
ebons74316092ebons
egos55821652egos
epos66723732epos
eros45238452eros
fabs98635862fab_s
fados95620732fados
fanos85926502fanos
faros85532022faros
fobs96034272fobs
gabs76740422gab_s
gobos86219372gobos
gobs76935572gobs
goos57644912goos
gos47155132_gos
habus106317142habus
halos85230252halos
hobos106321352hobos
hobs97038982hobs
hos68364192_hos
ibis66519582ibis
jabot14321512jabot
jabots1538882jabots
jabs135830092jab_s
jatos125116822jatos
jobs136529432jobs
kabob134113932kabob
kabobs14439302kabobs
kabs107130842kab_s
kayos127714702kayos
kobos115616892kobos
kobs105831082kobs
kos76944822_kos
labor75117312labor
labors84016402labors
labs67145122lab_s
lobos75921842lobos
lobs66441082lobs
loos49051122loos
mabes96331532mabes
makos116518362makos
mambos125414492mambos
manos74933612manos
mayos105521932mayos
mhos95517772mhos
mobs85737372mobs
moos66051302moos
mos57067122_mos
nabes75427092nabes
nabis76020582nabis
nabob93913742nabob
nabobs10388212nabobs
nabs66236192nab_s
naos47429732naos
nobs66436902nobs
nos38859322_nos
obas65730932obas
obes66036832obes
obis66226842obis
oboe66822942oboe
oboes75717712oboes
obol65220612obol
obols73715862obols
onos46229002onos
os211359882__os
poos65949112poos
pros65742782pros
ratos55528762ratos
rhos76319062rhos
robs65837872robs
sabes76437462sabes
sabot7931772sabot
sabots8314692sabots
sabs66643742sab_s
sagos66123872sagos
sambos104315192sambos
saros55238062saros
sobs64941752sobs
sos37761602_sos
tabes76033922tabes
taboo73418092taboo
taboos83815422taboos
tabor75518392tabor
tabors84517092tabors
tabs66842982tab_s
tabus74820922tabus
tacos77023552tacos
taos45541002taos
taros55640822taros
twos76718022twos
udos56619902udos
umbos94613072umbos
wabs97337232wab_s
woos76238802woos
wos66953532_wos
yobs96028082yobs
zoos135828802zoos

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.0802233637.5
2DLD Change Limit298723190.97030795.9
3Display Results3193190.0764197.4
 (SQL Overall)1786913191.126158695.4
 
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.