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

152 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
bonobos113639(None) 
bonobo1037141bonobo_
bonbon10310072bon_bon
bonbons1139332bonbons
bongos95316652bon_gos
bonitos939732bonitos
booboo1039462bo_oboo
booboos1138142bo_oboos
boobs96221992bo_ob_s
adobos9438453_adobos
baboos103517013babo_os
bamboos1348753bamboos
bancos104713893ban_cos
bandbox1943763bandbox
banjos15378893ban_jos
bazoos173212623bazo_os
benthos1238373benthos
bentos86218303ben_tos
bilbos105011203b_ilbos
bimbos124610523b_imbos
bingos95514793bin_gos
binocs1039923bino_cs
blobs95620033b_lob_s
bobs86340653b__ob_s
boffos14568193bo_ffos
bohos105618253b__ohos
boleros9310293boleros
bolos75531373b__olos
bombes124916823bo_mbes
bombs115818823bo_mb_s
bonacis11310323bonacis
bonders104120663bonders
bonds86126843bon__ds
bonducs1235553bonducs
boners84825433bon_ers
bones76446533bon__es
bongo85720943bon_go_
bongoes104314113bongoes
bongs87828423bon__gs
bonhomous1643843bonhomous
boniatos1046673boniatos
bonitas939453bonitas
bonito8313433bonito_
bonitoes1038153bonitoes
bonkers134015303bonkers
bonks116326463bon__ks
bonnes85621453bon_nes
bonnets94812803bonnets
bonnocks1644623bonnocks
bontebok1641933bontebok
bonteboks1741823bonteboks
bonus75324323bon__us
bonuses94212953bonuses
bonzes175116103bon_zes
boob85932583bo_ob__
boobed114514873bo_obed
boobie104015293bo_obie
boobies113718203bo_obies
boobish14338943bo_obish
booby125319513bo_ob_y
boocoo1039003bo_ocoo
boocoos1137753boocoos
boohoo1148833bo_ohoo
boohoos1237993boohoos
bookoo1248343bo_okoo
bookoos1337503bookoos
books115729713bo_o_ks
boombox2073613boombox
booms95427123bo_o_ms
boonies93422483boonies
boons75031913bo_o_ns
boors74325013bo_o_rs
boos67955033b__o_os
boosts86115013bo_osts
booths115313793bo_oths
boots75837973bo_o_ts
boozes174916523bo_ozes
borons85520543boro_ns
boshbok1844063boshbok
boshboks1943413boshboks
bosoms104913053boso_ms
bosons85016653boso_ns
boubou1038433bo_ubou
boubous1138693boubous
bourbon1135813bourbon
bourbons1245343bourbons
boyos105418283b__oyos
bozos165216863b__ozos
bromos104213313b_romos
bronchos15206173bronchos
broncos11188073bron_cos
broos75126413b_ro_os
buncos104011593bun_cos
bunkos124210323bun_kos
colobus11389373colobus
combos125316613co_mbos
conchos144313963conchos
condos94322333con_dos
congos94219883con_gos
conoids10813883conoids
contos84923233con_tos
donors75115793dono_rs
econobox1951583econobox
fynbos1433283fyn_bos
gobos86219383__gobos
gombos114311093go_mbos
gonofs10459863gono_fs
gonophs1344453gonophs
hobnobs1443603hobnob_s
hobos106321353__hobos
honchos15369573honchos
honors94816793hono_rs
honours10339373honours
ionones7313883ionones
jojobas1542233jojobas
knobs11519713_knob_s
kobos115616893__kobos
lobos75921843__lobos
longbow1343863longbow
longbows1443883longbows
mondos95217333mon_dos
mongos94318623mon_gos
monocot11412013monocot
monocots1249813monocots
monolog10259353monolog
monologs112210533monologs
monopod1247493monopod
monopods1347973monopods
monos75930863mon__os
moonbow1443873moonbow
moonbows1543953moonbows
nobs66436903__nob_s
nolos54423353__nolos
nomos75919743__nomos
nonbook1346283nonbook
nonbooks1446123nonbooks
nonegos837143nonegos
nonobese1044363nonobese
nonpros937473nonpros
onos46229003_on__os
ovibos1145463_ovibos
ovolos9257203_ovolos
ponchos143410703ponchos
rococos1145903rococos
rondos74616733ron_dos
snobs74716153_snob_s
sonobuoy1342133sonobuoy
sonobuoys1451403sonobuoys
sonorous8410413sonorous
sonovox1743013sonovox
tondos75115923ton_dos
yobbos1335963yo_bbos

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271526.92319359.7
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.35924282.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.