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

320 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
abound923986(None) 
abounds10217081abounds
around72712411around
bound84819581_bound
aboard9312612aboard
aboded104912512aboded
aboon74918702aboon_
abounded1234902abounded
about75229082abou_t
absurd935902absurd
aground9216182aground
airbound1144122airbound
aloud65018062alou_d
amount8414482amount
astound845502astound
bond75334362_bo_nd
bounds94415802_bounds
bund75530662_b_und
found94917842_found
ground82310272ground
hound95016482_hound
inbound10115772inbound
mound83918312_mound
obtund945582obtund
pound84417862_pound
rebound1058582rebound
round64318432_round
sound64420022_sound
stound7399902stound
swound10377632swound
unbound10158392unbound
upbound12134812upbound
wound94414212_wound
abased96514993abased
abated95918453abated
abduce1197193abduce
abduced1374843abduced
abduct11108543abduct
abed79734133ab__ed
abided105313313abided
abjure1536733abjure
abjured1735073abjured
abled86926833ab_led
ablins8316193ablins
abluent939623abluent
ablush1147223ablush
abluted10188363abluted
abo59045963abo___
abode85518813abo_de
abodes94417513abodes
aboding11410123aboding
abohm1247973abo_hm
abohms1335003abohms
aboil72217543abo_il
abolla8410193abolla
aboma91114603abo_ma
abomas101113583abomas
aboral8314373aboral
abort76133583abo_rt
aborted10310423aborted
aborts84916183aborts
abos67734413abo__s
abought1346143abought
aboulia966553aboulia
aboulic1156283aboulic
abounding1335193abounding
above105414323abo_ve
aboves114512843aboves
abroad9310943abroad
abrupt1039943abrupt
abscond1244503abscond
absent84016993absent
absurds1035003absurds
abuse77119563ab_use
abused95614273abused
abut66834953ab_u_t
abuts75417073ab_uts
abuzz15517213ab_uzz
abying124410413abying
account11109043account
acold86214923aco_ld
acorn75616623acorn_
acorned10238263acorned
acorns85013013acorns
addend9458453addend
adnoun757033adnoun_
adnouns835453adnouns
adored84714233adored
adorn64917093adorn_
adorned9256883adorned
adorns74212613adorns
adown95611663adown_
adunc837433a_dunc
aeon45634613aeo_n_
aeons57624653aeo_ns
afoul8510193afou_l
agon56531883ago_n_
agone65924553ago_ne
agons66423783ago_ns
agony96415653ago_ny
agouti7388763agouti
agouty10366913agouty
ahold94714253aho_ld
aland65526413a_land
aliunde835003aliunde
almond91410433almond
almud84012183almu_d
aloin55227413aloin_
aloins65022203aloins
alone55732963alo_ne
along65419493alo_ng
amboina1137953amboina
amboyna1443683amboyna
amend85717753a_mend
among85813303amo_ng
amounted1135533amounted
amounts937043amounts
amour75014853amou_r
amours83512643amours
and47244163a___nd
anoint6423633anoint
anon46134853ano_n_
aoudad835033a_oudad
apod78123183apo__d
apolune945283apolune
append1138273append
arbored103811603arbored
arbour84211323arbou_r
arboured1156253arboured
arbours93910033arbours
argued84311173argued
aroid65428333aro_id
aroint6328153aroint
arouse65019983arouse
aroused84914343aroused
aroynt9312893aroynt
ascend9429733ascend
astounds964233astounds
atone56527983ato_ne
atoned75417543atoned
atony87218853ato_ny
attend7258973attend
attune637983attune
attuned835173attuned
augend837633augend
auld54125363a__uld
aunt46553653a__unt
avaunt959603avaunt
avoid95516673avo_id
avouch1434833avouch
avowed1335953avowed
axon115524303axo_n_
axone125918473axo_ne
axons125517933axo_ns
azon135725053azo_n_
azons146518253azo_ns
azoted16388593azoted
baboon103613913baboon_
baboons113211073baboons
band76740903_b_and
baud74928423_bau_d
bend76435263_b_end
bind76234503_b_ind
bland85320453_bland
blend85317453_blend
blind86319323_blind
blond85618373_blond
blued84520323_blued
blunt75525023_blunt
board85523003_board
bod67055543_bo__d
boded95124963_boded
bohunk1533743_bohunk
boing84725553_boing
boink115516333_boink
bold75432813_bo_ld
bonds86126843_bo_nds
bone65949323_bo_ne
boned85133243_boned
bong75633413_bo_ng
bonk105531713_bo_nk
bonne75124713_bonne
bonny105816623_bonny
bonus75324323_bonus
bony96732083_bo_ny
booed85127273_booed
boon67142173_boon_
boons75031913_boons
bored85034303_bored
born67338413_born_
borne77926793_borne
bosun75113593_bosun_
bosuns8439383_bosuns
bough115719313_bough
boule74828043_boule
bounce104014833_bounce
bounced123610553_bounced
bouncy13409073_bouncy
bounded113613763_bounded
bounden10389453_bounden
bounder104215533_bounder
bounty113411073_bounty
bourg84113843_bourg
bourn75518483_bourn
bourne83714093_bourne
bourns84114063_bourns
bouse75931853_bouse
boused95322883_boused
bousy104917843_bousy
bout66353293_bou_t
bouts75131313_bouts
bovid111011623_bovid
bowed114533423_bowed
boxed154318613_boxed
brand85124493_brand
brung84613913_brung
brunt75728753_brunt
bud67041273_b_u_d
bun56348143_b_un_
buna64730723_b_una
bunds85523543_b_unds
bundt85824853_b_undt
bung75730633_b_ung
bunk105731353_b_unk
bunn65023653_b_unn
buns66243723_b_uns
bunt65850853_b_unt
burd75534263_b_urd
cloud86716423clou_d
cofound1335513cofound
could86517713_could
count74932053_count
defund11447983defund
disbound1245853disbound
drownd11478313drownd
eastbound1252333eastbound
ebon66821103ebo_n_
ebons74316093ebo_ns
ebony104511513ebo_ny
enwound11134813enwound
expound1744373expound
fecund1235433fecund
fogbound1542953fogbound
fond86330953_fo_nd
founds104814193_founds
fount84727033_fount
frond95316343fro_nd
fund85624983__fund
gaboon93211773gaboon_
gaboons10289893gaboons
gerund836163gerund
gourd71011903_gourd
grounds9228303grounds
hardbound1643413hardbound
hounds104413133_hounds
icebound1343423icebound
impound1235393impound
inbounds11134053inbounds
inwound11134973inwound
jocund1633623jocund
labored102810243labored
labour84210933labou_r
laboured1156323laboured
labours9349883labours
loud55228043_lou_d
maund85515443_maund
meoued9118533meoued
misbound1344933misbound
mould86015753_mould
mounds93915133_mounds
mount74128063_mount
noun45724183_noun_
nouns56717313_nouns
obtunds1033763obtunds
orotund844063orotund
osmund933803osmund
oud47439073__ou_d
outbound1146583outbound
poind84217913_poind
pond75530493_po_nd
potbound1344033potbound
pounds93714383_pounds
prebound1345893prebound
proud84615483prou_d
rebounds1156023rebounds
redound968173redound
refound1157413refound
refund104810303refund
resound869263resound
rewound1156433rewound
roband92310723roband
rotund737293rotund
rounds73615613_rounds
secund937103secund
should1038023should
sounds74616183_sounds
stounds8377823stounds
swoun84811493swoun_
swounds11405643swounds
swouned11366663swouned
swouns9358243swouns
tabooed10267383tabooed
tabored102810563tabored
tabouli945843tabouli
tabour84011313tabou_r
taboured1156273taboured
tabours94110073tabours
tabued94310403tab_ued
tabun75914373tab_un_
tabuns8489223tab_uns
thoued10429003thoued
unfound11127393unfound
unround8138503unround
unsound8158433unsound
unwound11126613unwound
would95513153_would
wounds103811633_wounds
yond86122313_yo_nd
young977743_young
zounds164310173_zounds

Search took 7 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.1431249587.4
2DLD Change Limit1127163206.57617140.5
3Display Results3203200.1102909.1
 (SQL Overall)1786913206.82926166.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.