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

429 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
bistred10331185(None) 
bistered112913321bistered
bistre83815021bistre_
bistres94017211bistres
basted95227232bast_ed
bested94922752best_ed
bestrew1248002bestrew
bestrid1039972bestrid
bilsted1038032bilst_ed
birred94713202bi_rred
birthed13228592birthed
bister84922762bist_er
bisters93922602bisters
bistro8339942bistr_o
bistros92810982bistros
bitted94418482bi_tted
bittered112711832bittered
blistered12167682blistered
bristled11187342bristled
busted95123152bust_ed
bustled104011512bustled
cisted95217522cist_ed
fisted104218702fist_ed
histed104420242hist_ed
listed74322832list_ed
lustred8359052lustred
misted93625822mist_ed
mitred94414342mi_tred
sistered92612802sistered
visored1138142visored
vistaed1138012vistaed
wisted104120272wist_ed
agisted938203agist_ed
aired66032923ai__red
airted74214503airt_ed
airthed11328303airthed
aisled74516183ais_led
assured858373assured
baited95319243bait_ed
banistered1394623banistered
bantered113313633bantered
bared85144483b__ared
barred95725793b_arred
bartered113113013bartered
based85331583bas__ed
bashed126225703bas_hed
basined10310003basined
basked135218603bas_ked
bastard103012423bastard
baste74829983bast_e_
baster85333593bast_er
basters94930303basters
bastes85330383bast_es
bated85935533b_at_ed
bathed125518743b_athed
batted95623653b_atted
battered113315053battered
battled104213123battled
beetled1038213beetled
belted94020633belt_ed
bemired123410633bemired
bemisted1368383bemist_ed
berthed13259123berthed
beshrew1554393beshrew
besotted1135843besotted
bespread1344183bespread
bestead10389113bestead
bestirred1243803bestirred
bestowed14156613bestowed
bestrewed1594163bestrewed
bestrewn1343323bestrewn
bestrews1335603bestrews
bestride1138613bestride
bestrode1147133bestrode
bestrow1237243bestrow
bestrowed1585163bestrowed
bestud9439303best_ud
betted94721163b_etted
bettered113011833bettered
bewared13310113bewared
bhistie1236763bhistie_
bhisties1339003bhisties
biased94012223bi_ased
biassed10418703biassed
bibbed104712343bi_bbed
bickered17108003bickered
bided95424963bi__ded
bielded11226713bielded
biffed15449883bi_ffed
biforked1842873biforked
biformed1643693biformed
bighted142810923bighted
bigoted11258403bigoted
biked125320033bi__ked
bilged105513183bi_lged
bilked134012943bi_lked
billed94224903bi_lled
bilobed1235913bilobed
bilsteds1134273bilst_eds
binged105920823bi_nged
binned94414543bi_nned
biotron937293biotron
bioturbed1441713bioturbed
biparted1335133biparted
biped104718833bi__ped
birched15349913birched
bird76128323bi__r_d
birded104414303bi_rded
birdied11329433birdied
birled94416993bi_rled
bise66437103bis__e_
bisected1336203bisected
bises75435623bis__es
bishoped1644663bishoped
bisque17257843bisque_
bisques18236893bisques
bistate9313813bistate
bistort91216523bistort
bistorts10118803bistorts
bistroic1246383bistroic
bitched153212923bitched
bite66547003bi_t_e_
biter75030033bi_t_er
biters83925233bi_ters
bites75641173bi_t_es
bitsier9379073bitsier
bitstream1342583bitstream
bitten84715123bi_tten
bitter84622673bi_tter
bitterer10309773bitterer
bittern94810683bittern
bitters94920353bitters
bittier94211663bittier
blared95018243b_lared
blasted104213473blast_ed
blatted104812713blatted
bleared104211253bleared
blissed10388373blis_sed
blister94415313blist_er
blisters104015083blisters
blistery13418713blistery
blitzed19336533blitzed
blotted103911833blotted
blurred10427803blurred
blurted10399783blurted
blustered12157263blustered
boasted104113743boast_ed
boated94221973boat_ed
bolstered1246083bolstered
bolted94617803bolt_ed
boosted104111983boost_ed
booted94822733boot_ed
bored85034303b__ored
bosomed1238003bosomed
bossed94816533bos_sed
bottled104611233bottled
bowered133113043bowered
bred75130973b___red
brisked144210003bris_ked
bristle91910103bristle_
bristles101510433bristles
brittled11186093brittled
bruted95113263brut_ed
bunted95219183bunt_ed
burred95820723b_urred
bursted1039423burst_ed
bused85624493bus__ed
bushed124822383bus_hed
busied95117223bus_ied
busked134917703bus_ked
bussed94717053bus_sed
bustard10389723bustard
buster84726493bust_er
busters94724123busters
bustier93916153bustier
bustle84015483bustle_
bustler94012563bustler
bustles93816323bustles
butled94818603b_utled
butted94722063b_utted
buttered112712623buttered
bystreet1345023bystreet
castled104311513castled
centred103411683centred
cistern93310693cistern
cistron9299883cistron
cited84421953ci_t_ed
citied94014143ci_tied
coistrel1046733coistrel
costed95623113cost_ed
costrel9310363costrel
desired9311983desired
dieted83115493diet_ed
dinted84419843dint_ed
dirtied93210853dirtied
disarmed1238643disarmed
disced104914653dis_ced
discoed11312483discoed
dished114318713dis_hed
disked125015763dis_ked
dispread1247103dispread
dissed85220183dis_sed
distend93312073distend
distorted1139363distorted
distress9311703distress
disturbed13195583disturbed
disused93211023disused
dittoed936733dittoed
dusted83918373dust_ed
ensured83512943ensured
existed1538473exist_ed
fasted105320953fast_ed
festered122512103festered
fibered1337643fibered
figured12196473figured
filtered12259043filtered
fired94829743fi__red
fished134316313fis_hed
fissured1235183fissured
fitted104716663fi_tted
foisted113210603foist_ed
fostered122210443fostered
gasted84821583gast_ed
gastrea847223gastrea
gestured1036993gestured
gifted114510703gift_ed
girted83912873girt_ed
girthed12266243girthed
gitted84015053gi_tted
glistered11176293glistered
gusted84316723gust_ed
hasted105125283hast_ed
hatred104814333_hatred
heisted113210653heist_ed
hilted104016043hilt_ed
hinted104318323hint_ed
hired95226263hi__red
hissed104114453his_sed
histoid1139813histoid
historied1347773historied
hoisted113411293hoist_ed
hosted105020343host_ed
hustled113210133hustled
inbred93010403_inbred
insured83714253insured
inured73114813_inured
ired55131873_i__red
isled64615993_is_led
issued746723_issued
istle52214713_istle_
istles62814983_istles
jested144416503jest_ed
jilted144111353jilt_ed
jittered16267223jittered
joisted15379173joist_ed
jostled15267083jostled
justed144215773just_ed
justled15338093justled
kestrel1137113kestrel
kilted113613833kilt_ed
kindred13316953kindred
kirtled12287033kirtled
kissed114412853kis_sed
kited105120093ki_t_ed
kithed144613013ki_thed
kitted115114833ki_tted
kittled12388193kittled
lasted74323603last_ed
leistered1037043leistered
leisured934763leisured
lifted104413523lift_ed
lilted73715373lilt_ed
linted74021823lint_ed
lisped94113423lis_ped
listee64223063list_ee
listees73416673listees
listel64214733list_el
listen64816813list_en
listened9168813listened
lister64527253list_er
listers74026523listers
litre55421463li_tre_
litres65220393li_tres
littered92511383littered
livered113111633livered
lusted74319443lust_ed
lustered92510603lustered
lustre64011683lustre_
lustres73013233lustres
masted94025803mast_ed
mastered112614003mastered
metred95315143_metred
milted93919943milt_ed
minored10310103minored
minstrel1046903minstrel
minted94220583mint_ed
mired85729223mi__red
miscued1239293miscued
misdeed113211053misdeed
misdrew1335833misdrew
misfed124113023mis_fed
misfeed13389683misfeed
misfired14238543misfired
misgrew1335523misgrew
misled94719313mis_led
mispled12310463mispled
misread10339723mis_read
missed94423603mis_sed
mistend103812523mistend
mister84728563mist_er
misterm114314513misterm
mistermed1438363mistermed
misters93927503misters
misthrew16124763misthrew
mistier93418713mistier
mistimed1339123mistimed
mistraced1439443mistraced
mistral91013633mistral
mistreat10313113mistreat
mistress10310703mistress
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283misused
mitered103213233mitered
mitre75522423mi_tre_
mitres83922073mi_tres
musted93321073must_ed
mustered112511503mustered
nested74720063nest_ed
nestled8349903nestled
nitre57519683ni_tre_
nitres65519333ni_tres
nitrid72812233ni_trid
osiered837123osiered
ousted73720583oust_ed
oystered1236913oystered
pasted94426903past_ed
pastored1139963pastored
pastured1138233pastured
pestered112814953pestered
pestled102711433pestled
philtred14114183philtred
piastre9307893piastre_
piastres10249303piastres
pictured1346573pictured
pished124817063pis_hed
pissed94816933pis_sed
piste75824603pist_e_
pistes85325633pist_es
pistoled11259593pistoled
pithed124615613pi_thed
pitied94017253pi_tied
pitted94319593pi_tted
posted93722493post_ed
postured1139493postured
rested74430783rest_ed
restored96417193restored
rifted104115313rift_ed
rioted73416373riot_ed
risked115514633ris_ked
ristra6310703ristr_a
ristras7311543ristras
roistered1037633roistered
rusted75020923rust_ed
rustled83311323rustled
sered65737293__sered
shred98125613__shred
sifted104313673sift_ed
silted74020013silt_ed
sintered92213903sintered
sired66134283__sired
sister64421583sist_er
sisters73721573sisters
sistra639333sistr_a
sistroid947253sistroid
sistrum946553sistrum
sited65130743si_t_ed
sored66141783__sored
stared75429873__stared
steed66024943__steed
stied65723033__stied
stored75524213__stored
strep77120853__strep
strew89220653__strew
styed95815483__styed
tasted74123973tast_ed
tested74421523test_ed
tiered73613973ti_ered
tilted74616863tilt_ed
tinted74419533tint_ed
tiptoed1036143tiptoed
tired65228903ti__red
tissued835583tissued
tithed104115593ti_thed
titled73815003ti_tled
titre54619393ti_tre_
titres64718933ti_tres
tittered9239493tittered
twisted11277433twist_ed
upstared11156573upstared
vested104217353vest_ed
vestured1237463vestured
visaed104110503vis_aed
visaged1235683visaged
visard103910123visar_d
vised95518763vis__ed
viseed105310983vis_eed
visited1168773visited
vittled11347343vittled
vizored2034133vizored
waisted114210943waist_ed
wasted104423023wast_ed
wastrel1037553wastrel
westered122511863westered
whisted144010013whist_ed
whistled1595783whistled
wilted103915713wilt_ed
wintered122111573wintered
wintled11339843wintled
wired95327643wi__red
wised95123343wis__ed
wished134417513wis_hed
wisped123411893wis_ped
wissed104114643wis_sed
wited94727143wi_t_ed
withed134416233wi_thed
witted104216813wi_tted
yirred10426963yi_rred
zested164214043zest_ed

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.1561145455.1
2DLD Change Limit1340274296.56320421.6
3Display Results4294290.1562750.0
 (SQL Overall)1786914296.87525991.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.