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

193 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
bishop133694(None) 
bishops1437031bishops
barhop13319642barhop
bishoped1644662bishoped
bison75716982bis_on
mishap1338872mishap
shop95629842__shop
airship1248513airship
airshot1059493airshot
airshow1344623airshow
bakeshop1942943bakeshop
barhops14288113barhops
bash915240163bash__
bashaw14349303bashaw
bashed126225703bashed
basher115123813basher
bashes115631393bashes
basion84315853basion
basso76017283basso_
bassos85313703bassos
bathos116215633bathos
bebop11410793b_ebop
bellhop1445053bellhop
beshout12311833beshout
besnow1145713besnow
besom95716973bes_om
besot76429713bes_ot
bestow1149463bestow
bicep115413543bi_cep
bicron103710773bicron
bighorn1346063bighorn
bight118728843bigh_t
bights124417963bights
bigos85020013bi_gos
bigot84828323bi_got
bijou1458793bi_jou
bilbo95513613bilbo_
bilboa10367843bilboa
bilbos105011203bilbos
billon83713833billon
billow114111223billow
bimbo114811873bimbo_
bimbos124610523bimbos
bingo86020093bingo_
bingos95514793bingos
bio57846083bi__o_
biochip1645323biochip
biog76122323bi__og
bios66335323bi__os
bioscope1446483bioscope
bioscopy1743823bioscopy
biotope1146623biotope
bipod104410823bi_pod
birdshot1444193birdshot
biro66131213bi_ro_
biros75325133bi_ros
bis56860663bis___
bise66437103bis__e
bisect10312873bisect
bises75435623bis_es
bishoping1744283bishoping
bishopric1852063bishopric
bisk106523353bis__k
bisks115416803bis_ks
bisons83914373bisons
bisque17257843bisque
bister84922763bister
bistort91216523bistort
bistre83815023bistre
bistro8339943bistro
bistros92810983bistros
bitmap1235613bitmap
bloop96116153b_loop
boho96923323b_oho_
bohos105618253b_ohos
boohoo1148833boohoo
bookshop1943423bookshop
bop77549483b___op
bosh96328973bosh__
boshbok1844063boshbok
boshes114721883boshes
bosom95516923bos_om
boson76019733bos_on
boston8513043boston
bowshot1578253bowshot
bristol937043bristol
brushup1443513brushup
busboy13307443busboy
bush96630713bush__
bushed124822383bushed
bushel114513943bushel
busher114922203busher
bushes115226113bushes
bushwa14105143bushwa
bushy135416683bush_y
carhop133610763carhop
cashoo11312253cashoo
chop116024923__chop
cisco95112133cisco_
ciscos104711133ciscos
disco85616073disco_
discos94915213discos
dish86328333dish__
dished114318713dished
dishes104622653dishes
dishy125712353dish_y
estop74312103_estop
fish106926273fish__
fished134316313fished
fisher124917143fisher
fishes125221343fishes
fishy146011663fish_y
gismo848863gismo_
gismos957183gismos
hightop1645013hightop
hipshot15106643hipshot
hop87554593___hop
hyssop1443413hyssop
ichor1039483_ichor
kinship1645823kinship
kishka1232963kishka
kishke1254273kishke
lisp68926883lis__p
lissom837403lissom
litho86513783litho_
lithops12307253lithops
lithos94212553lithos
midship1546043midship
miscopy1636663miscopy
misdo85413183misdo_
mishaps1438723mishaps
mishit112618203mishit
miso67229903mis_o_
misos76523293mis_os
misshod1335873misshod
misstop11156413misstop
pisco96314983pisco_
piscos105112593piscos
pish96127913pish__
pished124817063pished
pisher114317753pisher
pishes114722103pishes
pishoge1336693pishoge
piso66727563pis_o_
pisos76021063pis_os
pistol83313333pistol
piston83515923piston
pistou83211843pistou
postop10511943postop
pushup1335273pushup
reship11310673reship
reshod103012233reshod
reshoe92816483reshoe
reshot93519633reshot
reshow123111433reshow
rimshot1246213rimshot
ripstop1174763ripstop
rishi8311253rish_i
rishis9312453rishis
scop85925523__scop
ship95228243__ship
shod86225063__shod
shoe75933443__shoe
shog86025143__shog
shoo75929893__shoo
shops104222903__shops
shot76150263__shot
show106229193__show
siphon1138463siphon
slop66533873__slop
sop57557863__s_op
stop66532033__stop
swop95120503__swop
sysop1037193sys_op
teashop1246083teashop
tiptop1036103tiptop
toyshop1544873toyshop
unship1148033unship
unshod1067603unshod
unstop837473unstop
upshot1138453upshot
vision9311313vision
visor82512833vis_or
washup1435323washup
whop125520923__whop
wineshop1643763wineshop
wisdom1235983wisdom
wish107228733wish__
wisha114910853wish_a
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wisp97124073wis__p

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.373479064.3
2DLD Change Limit1127161935.47020606.2
3Display Results1931930.0633063.5
 (SQL Overall)1786911935.90630255.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.