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

114 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
bespoke1546811(None) 
besmoke15416621besmoke
bespake15436961bespake
bespoken16505011bespoken
respoke134311281respoke
besmoked17405412besmoked
besmokes16406362besmokes
bespouse1245112bespouse
respoken14506922respoken
restoke116113902restoke
spoke114818662__spoke
unspoke1336572unspoke
beanpole1244333beanpole
become123312593be_come
bedlike14369533bedlike
bedpost1247243bedpost
bedsore1057803bedsore
beelike13379783beelike
before11410153be_fore
begone9512133be_gone
behoove1553773behoove
behove14207203be_hove
belike124616283be_like
benzole1837133benzole
berake124216083be_rake
bescour1145203bescour
beshame1447483beshame
beshout12311843beshout
beside95114613bes_ide
besiege1035413besiege
beslime1146833beslime
besmile1137463besmile
besnow1145713besno_w
besnowed14124413besnowed
besnows1245153besnows
besom95716973bes_o_m
besoms105712733bes_oms
besoothe1343783besoothe
besot76429713bes_o_t
besots86415453bes_ots
bespeak1544573bespeak
bespeaks1643963bespeaks
bespoused1443773bespoused
bespouses1345153bespouses
bestow1149463besto_w
bestowed14156623bestowed
bestower13126213bestower
bestows1248863bestows
bestrode1147143bestrode
betake124512703be_take
betoken13386503be_token
betook12439603betook_
blesbok1543123blesbok_
blesboks1643043blesboks
bloke114316633b__loke
broke116019783b__roke
cestode1037963cestode
cowpoke1835103cowpoke
depone93616553de_pone
depose94215763de_pose
despise1038683despise
despite10410123despite
despoil1046523despoil
despond1137513despond
despot93413293despo_t
despots10319683despots
dispose10312763dispose
disyoke1546233disyoke
epode85114093_e_pode
espouse936403_espouse
evoke12478853_e_voke
expose1549523_expose
forespoke18105263forespoke
misspoke1645413misspoke
misyoke1635823misyoke
mopoke1436633_mopoke
muspike1536043muspike
oospore939013oospore
outspoke1446493outspoke
poke105335363___poke
reawoke14397443reawoke
reevoke14386363reevoke
repose84121413re_pose
rescore95616203rescore
reshoe92816483resho_e
reshone102414163reshone
resole64624183res_ole
respace11310913respace
respade1039573respade
respire9411543respire
respite9513033respite
respond1039113respond
response1037753response
respool937643respool
respot83117633respo_t
respots92912763respots
restoked135710533restoked
restokes125213043restokes
restore75822983restore
revoke135216243re_voke
rewoke1339521223re_woke
smoke115015823__smoke
soke85436263__s_oke
spake114322743__spake
spike114922843__spike
spode84617703__spode
spoked134413893__spoked
spoken124610003__spoken
spokes124417213__spokes
spore75428593__spore
stoke94922513__stoke
unspoken1454243unspoken
vespine1237903vespine
zeppole2043493zeppole

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.406440125.6
2DLD Change Limit1340271147.22018563.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.