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

230 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
bonaci1031096(None) 
bonacis11310321bonacis
bocci113512712bo_cci
bonsai838462bonsai
boracic1338722boracic
monacid121310242monacid
nonacid101210842nonacid
abaci94718843_abaci
abomasi11115493abomasi
bach116131393b__ach
back125535763b__ack
banal75925993bana_l
banana83213413banana
banco94019393ban_co
bani65334963b__ani
banzai1737653banzai
beach124623893b_each
bename103316073bename
bench125619503ben_ch
benni74715363ben_ni
biali73419073b_iali
biface1358103biface
binal75323823bina_l
binary11312223binary
binate8419773binate
bindi85617013bin_di
binocs1039923binocs
bionic103614573bionic_
bionics114310873bionics
biontic1148333biontic
bipack1636523bipack
black134719073b_lack
blanch133410853blanch
bleach133611403bleach
boa56954033bo_a__
boar66134293bo_a_r
board85523003bo_ard
boars75229603bo_ars
boart78835933bo_art
boas66150833bo_a_s
boast75935703bo_ast
boat66360313bo_a_t
boats75635153bo_ats
bobcat12411253bobcat
bocaccio1352273bocaccio
bocce114313113bo_cce
boccia12338793bo_ccia
boccie123311453bo_ccie
boccis123911133bo_ccis
bock126032513bo__ck
bodice11711423bodice
bogan87519003boga_n
bogans95714813bogans
bogart9617193bogart
bola66035563bola__
bolar75123473bola_r
bolas74733763bola_s
boleti8413403boleti
bonanza1843843bonanza
bonbon10310073bonbon
bond75334363bon__d
bondage1138253bondage
bonded104719953bonded
bonder95324783bonder
bonds86126843bon_ds
bonduc1136603bonduc
bonducs1235553bonducs
bone65949323bon__e
boned85133243bon_ed
boner75133083bon_er
boners84825433boners
bones76446533bon_es
boney105227313bon_ey
bong75633413bon__g
bonged105719603bonged
bongo85720943bon_go
bongos95316653bongos
bongs87828423bon_gs
boniato947283boniato
bonier84321993bonier
boniface1543863boniface
boning94223293boning
bonita8312943bonita
bonito8313433bonito
bonk105531713bon__k
bonked135517313bonked
bonks116326463bon_ks
bonne75124713bon_ne
bonnes85621453bonnes
bonnet85524633bonnet
bonnie85314853bonnie
bonnock1545203bonnock
bonny105816623bon_ny
bonobo1037143bonobo
bonus75324323bon_us
bony96732083bon__y
bonze165119353bon_ze
bonzer175313673bonzer
bonzes175116103bonzes
bora66141633bora__
boraces113716853boraces
boracite1249193boracite
borage93917013borage
boral75831703bora_l
borals86721913borals
borane84620213borane
boras75938303bora_s
borate85026153borate
borax145918723bora_x
boric98024223boric_
borsch1336133borsch
borzoi1736623borzoi
bota66236503bota__
botanic1159583botanic
botany1139263botany
botas75328783bota_s
botch126717453bo_tch
bounce104014833bounce
bouncy13409073bouncy
boxcar1734753boxcar
boyar106013763boya_r
boyard125411283boyard
boyars115611983boyars
brace95629273b_race
brach126123303b_rach
bract96332723b_ract
branch134014783branch
bravi104715753b_ravi
breach134213723breach
broach133611113broach
bronc91714343bron_c_
bronchi14176313bronchi
bronco10179493bron_co
broncs101611153bron_cs
buna64730723buna__
bunas75126573buna_s
bunch125118603bun_ch
bunco94616083bun_co
byname13256363byname
coach125919453co_ach
coact96130583co_act
coati75624643co_ati
cocci82812673co_cci
coenact11311803coenact
cognac1157273cognac_
cognacs1256043cognacs
conch124620073con_ch
congii957363congii
coni65534803con__i
conic95329793conic_
conics103920593conics
contact1144020683contact
denari710917353denari
dolci84912603do_lci
dona55529633dona__
donas65926473dona_s
donate73619503donate
ebonics1137193ebonics
enact73525363_enact
foci94521013fo__ci
folacin1238053folacin
gonad75216053gona_d
gonadic1177213gonadic
gonads84511733gonads
honan85319773hona_n
honans94814503honans
hongi96715873hon_gi
ionic74622663ionic_
ionics84214483ionics
knack104311043_knack
korai97018523kora_i
lanai5319573lana_i
linac7315413linac_
linacs8310813linacs
loach105116363lo_ach
loci66126283lo__ci
lunacy1136843lunacy
menace103216943menace
monacids13137513monacids
monad85519473mona_d
monadic1268883monadic
monads94515303monads
monarch1445953monarch
monas74732153mona_s
monoacid13137223monoacid
mosaic10311143mosaic
naoi46024633__naoi
nazi136219873__nazi
nona46929063nona__
nonacids11148263nonacids
nonage7313683nonage
nonart6319193nonart
nonas55126653nona_s
nonce75719823non_ce
nonfact1248893nonfact
okapi1136613_okapi
onagri754963_onagri
once65423083_on_ce
ontic74418573_ontic
oorali6311263oorali
orach105219233_orach
poach124917863po_ach
pomace123111913pomace
ponce95222513pon_ce
roach105717003ro_ach
romaji1534893romaji
snack114718063_snack
solace83415823solace
sonance9310313sonance
sonant6621953sonant
sonar56523423sona_r
sonars64818973sonars
sonata6313223sonata
sonic75225293sonic_
sonics84315633sonics
souari6311383souari
tenace82715693tenace
tonal53724303tona_l
tondi65716143ton_di
tonic74727653tonic_
tonics83617863tonics
unai44824783_una_i
unci65019463_un_ci
yoni77524393yon__i
yonic105920843yonic_
zona136321963zona__
zonae145116443zona_e
zonal145116853zona_l
zonary1838793zonary
zonate154114923zonate

Search took 9 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.766233278.1
2DLD Change Limit1127162307.98314119.5
3Display Results2302300.0633650.8
 (SQL Overall)1786912308.81220278.1
 
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.