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

164 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
bishops143703(None) 
bishop1336941bishop_
barhops14288112barhops
bishoped1644662bishoped
bisons83914372bis_ons
lithops12307252lithops
mishaps1438722mishaps
shops104222902__shops
airships1347713airships
airshots1145943airshots
airshows1444163airshows
bakeshops2042833bakeshops
barhop13319643barhop_
bashaws15347713bashaws
bashers124820833bashers
bashes115631393bash_es
basions94213953basions
bassos85313703basso_s
bathos116215633batho_s
bebops1237623b_ebops
bellhops1544873bellhops
beshout12311833beshout
beshouts1346763beshouts
besnows1245153besnows
besoms105712733bes_oms
besots86415453bes_ots
bestows1248863bestows
biceps12447713bi_ceps
bicrons113410473bicrons
bighorn1346063bighorn
bighorns1445253bighorns
bights124417963bigh_ts
bigos85020013bi_go_s
bigots95015133bi_gots
bijous1548043bi_jous
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
bilious9310933bilious
billons93013363billons
billows123611293billows
bimboes13498733bimboes
bimbos124610523bimbo_s
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bi_nocs
biochips1744843biochips
biogs85016113bi__ogs
biopsy1334533bi__opsy
bios66335323bi__o_s
bioscope1446483bioscope
bioscopes1546553bioscopes
bioscopy1743823bioscopy
biotope1146623biotope
biotopes1246963biotopes
bipods11408593bi_pods
biros75325133bi_ro_s
bisects1137133bisects
bises75435623bis__es
bishoping1744283bishoping
bishopric1852063bishopric
bishoprics1951483bishoprics
bisks115416803bis__ks
bison75716983bis_o_n
bisques18236893bisques
bisters93922613bisters
bistort91216523bistort
bistorts10118813bistorts
bistres94017213bistres
bistros92810983bistros
bitmaps1344253bitmaps
bloops106611343b_loops
bohos105618253b_oho_s
boohoos1237993boohoos
bookshops2043463bookshops
bops86037983b___ops
boshboks1943413boshboks
boshes114721883bosh_es
bosoms104913053bos_oms
bosons85016653bos_ons
bostons9312903bostons
bowshots1645103bowshots
bristols1046773bristols
brushups1542713brushups
busboys14325023busboys
bushels124110713bushels
bushers124018803bushers
bushes115226113bush_es
bushwas15105613bushwas
carhops14329703carhops
cashoos12310793cashoos
chops125019873__chops
ciscoes113610733ciscoes
ciscos104711133cisco_s
discos94915213disco_s
dishes104622653dish_es
estops84011223_estops
fishers134714723fishers
fishes125221343fish_es
gismos957183gismo_s
hightops1745043hightops
hops97942633___hops
hyssops1543123hyssops
ichors11310423_ichors
kinships1745793kinships
kishkas1343483kishkas
kishkes1334773kishkes
lisps76913913lis__ps
lithos94212553litho_s
midships1645693midships
miscopy1636663miscopy
misdoes10312493misdoes
mishap1338873mishap_
mishits122513083mishits
misos76523293mis_o_s
misstops12176413misstops
piscos105112593pisco_s
pishers123815753pishers
pishes114722103pish_es
pishoge1336693pishoge
pishoges1446953pishoges
pisos76021063pis_o_s
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
postops11311713postops
psyops1334343_psyops
pushups1433653pushups
reships1239863reships
reshoes102316033reshoes
reshows132510453reshows
rimshots1343883rimshots
ripstops1265013ripstops
rishis9312453rish_is
scops95820193__scops
ships105123773__ships
shoes85429663__shoes
shogs95319713__shogs
shoos84226363__shoos
shop95629843__shop_
shots84730853__shots
shows115324583__shows
siphons1239353siphons
slops75026013__slops
sops65244563__s_ops
stops74827283__stops
swops105913973__swops
sysops1136013sys_ops
teashops1345733teashops
tiptops1136073tiptops
toyshops1644433toyshops
unships1237203unships
unstops936993unstops
upshots1235193upshots
viscous1238833viscous
visions10311023visions
visors92912223vis_ors
washups1534683washups
whops135013933__whops
wineshops1743963wineshops
wisdoms1335453wisdoms
wishers133215213wishers
wishes124920953wish_es
wisps105214183wis__ps

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271645.70323501.1
3Display Results1641640.0463565.2
 (SQL Overall)1786911646.15529031.8
 
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.