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

389 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
aboard931261(None) 
board85523001_board
abfarad1344222abfarad
aboded104912512aboded
aboral8314372aboral
abort76133582abo_rt
abound9239862abound
abroad9310942abroa_d
absurd935902absurd
afeard1058262afeard
award97118042a_ward
bard75648862_b_ard
bayard124411662bayard
beard86024962_beard
boar66134292_boar_
boards94616932_boards
boars75229602_boars
boart78835932_boart
boyard125411282_boyard
gabbard1336552gabbard
garboard1247242garboard
hoard94918312_hoard
inboard1037062inboard
lapboard1355782lapboard
larboard1157662larboard
onboard1046502onboard
reboard10310762reboard
seaboard1147432seaboard
tabard9313332tab_ard
tagboard1245562tagboard
teaboard1146292teaboard
aba512850953ab_a__
abaca95118043ab_aca
abaci94718843ab_aci
aback134816173ab_ack
abaft10318063ab_aft
abaka114313823ab_aka
abamp11310603ab_amp
abas68642083ab_a_s
abase76023483ab_ase
abased96514993abased
abash106016513ab_ash
abate76627843ab_ate
abated95918453abated
abaya104413173ab_aya
abba810522653abba__
abbacy1536623abbacy
abbas95918643abba_s
abeam9316533abea_m
abed79734133ab__ed
abfarads1443163abfarads
abhor10411063abhor_
abhorred1443493abhorred
abhors11410623abhors
abided105313313abided
abjure1536743abjure
abjured1735083abjured
ablate82219213ablate
ablated102513443ablated
ablaut8313263ablaut
ablaze17239833ablaze
abled86926833ab_led
abler75624313abler_
abo59045963abo___
abode85518813abo_de
abodes94417513abodes
abohm1247973abo_hm
abohms1335003abohms
aboil72217543abo_il
abolla8410193abolla
aboma91114603abo_ma
abomas101113583abomas
abomasa11114613abomasa
abomasi11115493abomasi
aboon74918703abo_on
aborted10310423aborted
aborts84916183aborts
abos67734413abo__s
abounds10217083abounds
about75229083abo_ut
above105414323abo_ve
aboves114512843aboves
abrade9313053abrade
abraded1138643abraded
abri65522213ab__ri
abroach1446213abroach
absorb1038013absorb
absurds1035003absurds
abused95614273abused
abwatt11410673abwatt
acari75020283a_cari
acarid95017073a_carid
accord1178843accord
acold86214933aco_ld
acorn75616623aco_rn
adore65723673ado_re
adored84714243adored
adorn64917093ado_rn
afar76720783a_far_
afars85716513a_fars
afeared1176833afeared
afford1346493afford
afore85818603afo_re
afraid1049723afraid
agar58726413a_gar_
agars66120643a_gars
aglare7312423aglare
agora6914333ago_ra
agorae7511203agorae
agoras7613343agoras
ahead96817053ahea_d
ahold94714253aho_ld
airward1148133airward
ajar116217703a_jar_
aland65526413a_land
alar46340073a_lar_
alarm76621423a_larm
alary86123443a_lary
aloud65018073alo_ud
altar55520643altar_
altars64518153altars
ambari103012173ambari
ambary134010543ambary
amoral8314633amoral
amort75832203amo_rt
amour75014853amour_
amours83512663amours
anear55420323anear_
aneared8512743aneared
anears63717183anears
angary10311323angary
anoa45634473anoa__
anoas57226493anoa_s
anorak1038923anorak
apart74330673a_part
apiary113910383apiary
apocarp1355133apocarp
apod78123183apo__d
aport75432173apo_rt
arbor74818113arbo_r_
arbored103811603arbored
arbors84717883arbo_rs
arbour84211333arbour_
arboured1156253arboured
arbours93910043arbours
ariary94114203ariary
aroid65428343aro_id
around72712413around
ascared10399523ascared
ascarid103910723ascarid
aswarm11107913aswarm
atoned75417543atoned
attar56516693attar_
attars64515313attars
audad71511393auda_d
aurar54420253aurar_
aviary12338413aviary
avoid95516683avo_id
avowed1335963avowed
awards107113453a_wards
aware86420023a_ware
aweary1237303aweary
awkward1843183awkward
azoted16388593azoted
baaed85218163_baaed
backboard2047183backboard
bad67763153_b_a_d
bald76432903_b_ald
band76740913_b_and
bar58070553_b_ar_
barb85240063_b_arb
barde85330773_b_arde
bards87139643_b_ards
bare65460523_b_are
bared85144483_b_ared
barf95844413_b_arf
bark106242153_b_ark
barm86739603_b_arm
barn66444643_b_arn
bars66564093_b_ars
baseboard1445543baseboard
bastard103012423bastard
baud74928423_b_aud
bawd105520843_b_awd
bayards13379683bayards
bazar163816003bazar_
bazars174613113bazars
bead75937923_bea_d
bear66844643_bear_
beards94116673_beards
bears75739043_bears
bedboard14115723bedboard
bird76128323_b_ird
bland85320453_bland
blare75826233_blare
blared95018243_blared
boa56954033_boa__
boarded113910503_boarded
boarder103910323_boarder
boarts84716873_boarts
boas66150833_boa_s
boast75935703_boast
boat66360313_boa_t
boated94221973_boated
boats75635153_boats
bod67055543_bo__d
boded95124963_boded
bogart9617193_bogart
bolar75123473_bolar_
bold75432813_bo_ld
bollard103210503_bollard
bombard1437333_bombard
bond75334363_bo_nd
boned85133243_boned
booed85127273_booed
boor66130683_boor_
boors74325013_boors
bora66141633_bo_ra
boral75831703_boral
boras75938303_boras
borax145918723_borax
bore66051333_bo_re
bored85034303_bored
bork106933823_bo_rk
born67338413_bo_rn
bort65960963_bo_rt
bound84819583_bound
bourg84113843_bourg
bourn75518483_bourn
bovid111011623_bovid
bowed114533423_bowed
boxboard2044613boxboard
boxed154318613_boxed
boyar106013763_boyar_
boyards13399323_boyards
boyars115611983_boyars
brad75234343_bra_d
braid85822263_braid
brand85124493_brand
briard94311293briard
broad84817693broa_d
burd75534263_b_urd
callboard1445663callboard
canard9314763canard
card710245873__card
cardboard1545863cardboard
chard116124743_chard
chord115917263cho_rd
clapboard1683953clapboard
cord76740923_co_rd
coward12411673coward
cupboard1544253cupboard
dartboard1344253dartboard
dashboard1643803dashboard
dastard9279703dastard
debeard1137353debeard
dotard839053dotard
echard1249223echard
fallboard1545053fallboard
fard85639063__fard
fiord94313343fio_rd
fjord16477023fjo_rd
ford86835493_fo_rd
froward1436673froward
gabbards1445753gabbards
gabbart1248883gabbart
garboards1346363garboards
goad66830983_goa_d
gourd71011903_gourd
guard74415543_guard
haggard13377183haggard
halyard1476973halyard
hard85443503__hard
hardboard1645583hardboard
hayward1736413hayward
hazard1938403hazard
headboard1644933headboard
heard95222753_heard
hoar76729163_hoar_
hoards104912623_hoards
hoars85925553_hoars
hoary114516763_hoary
holard10410573holard
inboards1145843inboards
inward10310333inward
izzard15135243izzard
jeopard1744113jeopard
kabar114815553kab_ar_
kabars124513953kab_ars
kbar106514653kb_ar_
kbars114612603kb_ars
keyboard1844503keyboard
labara83712893lab_ara
labor75117313labo_r_
labored102810243labored
labors84016413labo_rs
labour84210933labour_
laboured1156323laboured
labours9349893labours
laggard10347623laggard
laniard868523laniard
lanyard1167293lanyard
lapboards14105373lapboards
larboards1246983larboards
lard56742003__lard
leeboard1145433leeboard
leopard1045293leopard
leotard846193leotard
liard65418593_liard
lizard16369233lizard
load56730603_loa_d
lobar7313013lobar_
lord55032083_lo_rd
lyard95113213_lyard
mallard10310273mallard
mansard1049313mansard
manward1349093manward
mazard1838763mazard
mazzard1844463mazzard
mopboard1543983mopboard
nard56634453__nard
oar37057953__oar_
oared65030653__oared
oars46846033__oars
onward1039053onward
orad56031693__orad
outboard1138323outboard
packboard2044843packboard
pard76441323__pard
pegboard1444803pegboard
petard95013803petard
preboard1338263preboard
reboards1138773reboards
regard85215773regard
retard75018933retard
reward106017643reward
ritard74812083ritard
road56332113_roa_d
roar46328573_roar_
roared75015393_roared
roars55622243_roars
roband92310723roband
rubboard1343983rubboard
saggard10358953saggard
sailboard1245903sailboard
sard55344243__sard
scabbard1544203scabbard
seaboards1246443seaboards
shard96125963_shard
skyboard1844003skyboard
soar46838673_soar_
soared74324293_soared
soars54732513_soars
sord56237203_so_rd
starboard1275843starboard
sward94221463_sward
sword95214123swo_rd
tabards10310383tab_ards
tabooed10267383tabooed
tabor75518393tabo_r_
tabored102810563tabored
tabors84517113tabo_rs
tabour84011323tabour_
taboured1156273taboured
tabours94110093tabours
tackboard1844723tackboard
tagboards1345133tagboards
tailboard1245773tailboard
tankard1267263tankard
tanyard1167183tanyard
teaboards1245393teaboards
toad55830183_toa_d
toward10311063toward
uphoard1344573uphoard
upward12147163upward
vanward1456943vanward
vaward13498723vaward
visard103910123visard
vizard19458853vizard
wakeboard1944753wakeboard
wallboard1545023wallboard
ward86542253__ward
washboard1844523washboard
wayward1736053wayward
wizard19377713wizard
woad85523943_woa_d
woald94813073_woald
word89832003_wo_rd
yard85633253__yard

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 Limit1127163895.46620621.3
3Display Results3893890.1103536.4
 (SQL Overall)1786913895.95230022.0
 
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.